Mysql Row to Column

Select*  from where a.batch_no = '    ss20170123181418'  ;

This is the original data:

This is what it looks like after a row-to-column:

SelectA.debt_type,sum( Case   whenDebt_type='0'   ThenAMOUNTEND)'Initial Debt',sum( Case   whenDebt_type='1'   ThenAMOUNTEND)'Level Two debt' , CONVERT(Group_concat (Debt_type,'Total:', AMOUNT) USING UTF8) as 'Stitching Totals',sum(AMOUNT) as 'Total'   fromT_zg_asset_statistic_info awhereA.batch_no='ss20170123181418'GROUP  byA.debt_typeORDER  byA.debt_type;

PostScript: MySQL blob field to string method

CONVERT (Group_concat (Debt_type,' total:', AMOUNT) USING UTF8)

Mysql Row to Column