Rotating the data in a worksheet

  • Thread starter Thread starter Carol
  • Start date Start date
C

Carol

I am fairly limited on knowledge for excel so any help would be appreciated.
I am importing data from another program into excel. I need to have the data
in cells listed in each row converted to data in columns... Please help.
 
so, you want to transpose the data?

Copy the set, go to a blank spot, Edit/Paste Special and check the transpose
box.
 
Depending upon the layout you may be able to do a simple copy>paste
special>transpose.

See help for more.

Or post more details on your layout.


Gord Dibben MS Excel MVP
 
Back
Top