Row to Column

B

Brian

I have a row with 94 entries.

I would like this data converted to a column instead.

Is there an easy way to accomplish this?

Thank you.
 
G

Gord Dibben

Brian

Copy the row. Assume row 1

Select A2 and Paste Special>Transpose>OK>Esc.


Gord Dibben Excel MVP
 
B

Brian

Thank you Gord, worked like a charm.

Gord Dibben said:
Brian

Copy the row. Assume row 1

Select A2 and Paste Special>Transpose>OK>Esc.


Gord Dibben Excel MVP
Click to expand...
 
G

Gord Dibben

bass

OP stated "94 entries" so will have no problem, but thanks for the added
caveat.

Gord
 
Top