case when source = 'hyderabad' then 'bangalore' else ' ' end as hyderabad, case when source = 'mumbai' then 'delhi' else ' ' end as mumbai, case when source = 'bangalore' then 'hyderabad' else ' ' end ...