converting data from rows to colomns.

[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

 

[Joe]

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...