converting data from rows to colomns.

  • Thread starter Thread starter binod
  • Start date Start date
B

binod

i have database which are in rows, which should be
converted in columns.

eg.
name
address
city

name
adress
city

to be converted to

name adress city
 
Try this...

Copy the data you want to alter...
Select "Paste Special" and select the "Transpose" check
box on the "Paste Special" window... select a new cell
and click OK...
 
Back
Top