SELECT Name,
SUM(CASE WHEN Group = 'Conveyance' THEN Expense ELSE 0 END) AS  ConveyanceExpense,
SUM(CASE WHEN Group = 'Conveyance' THEN Budget ELSE 0 END) AS  ConveyanceBudget,
SUM(CASE WHEN Group = 'Conveyance' THEN Variation ELSE 0 END) AS  ConveyanceVariation,
SUM(CASE WHEN Group = 'Travel Allownce' THEN Expense ELSE 0 END) AS  TravelAllownceExpense,
SUM(CASE WHEN Group = 'Travel Allownce' THEN Budget ELSE 0 END) AS  TravelAllownceBudget,
SUM(CASE WHEN Group = 'Travel Allownce' THEN Variation ELSE 0 END) AS  TravelAllownceVariation
FROM tablename
GROUP BY Name