Converting from rows to columns

T

Tripp K

I have data that was given to me in a csv that has each entry point in a row
going horizontally. But I need to export the data in a format with a header,
so I need to get it into a vertical column. Can someone help me make this
conversion happen - I am sure it is something simple.

THanks in advance,
 
P

Prasadkakarla

Dear Mr. Tripp

its is very easy to change the row data to column and as well column data
to row
with the help of paste special there is an excelent option " Transpose'

use this : copy the data then go to the cell where u want to , right
click, paste special , click Transpose option then enter the ok , u will
get the transpose data

copy > paster special > click Transpose
 
Top