SELECT purchasedate,
SUM(CASE WHEN category = 'Bills' THEN amount ELSE 0 END) Bills,
SUM(CASE WHEN category = 'Travel' THEN amount ELSE 0 END) Travel,
SUM(CASE WHEN category = 'Choose...' THEN amount ELSE 0 END) Choose,
SUM(CASE WHEN category = '1' THEN amount ELSE 0 END) 1_,
SUM(CASE WHEN category = '2' THEN amount ELSE 0 END) 2_,
SUM(CASE WHEN category = '5' THEN amount ELSE 0 END) 5_,
SUM(CASE WHEN category = 'food' THEN amount ELSE 0 END) food,
SUM(CASE WHEN category = 'Food' THEN amount ELSE 0 END) Food,