how to do Row to column pivot/transposition

asked 2018-09-14 12:23:29 -0600

bava gravatar image

updated 2018-09-17 01:45:46 -0600

how could do row to column conversion when i have data like this

columns,   Values 
name ,     kadir
city ,   Bangalore
country,    India
mobile ,    XXXXX55

the output should be..
name ,  city,  address,  country,  mobile 
kadir,  Bangalore,   India,    XXXXX55
edit retag flag offensive close merge delete


name, city, country, mobile are separate lines of text in the input?

metadaddy gravatar imagemetadaddy ( 2018-09-14 13:35:21 -0600 )edit

no , its comma separated values

bava gravatar imagebava ( 2018-09-17 01:46:33 -0600 )edit

I'm still not sure what the input and output formats are. You said the input is comma separated values, but that's what your output looks like.

metadaddy gravatar imagemetadaddy ( 2018-09-21 21:50:09 -0600 )edit