Solved Convert long row of data to one column

October 8, 2011 at 14:34:34
Specs: Windows 7
I have a data in a long row - about 2000 columns wide.

I need to convert it into one column with 2000 rows.

Please help!


See More: Convert long row of data to one column

Report •


#1
October 8, 2011 at 17:32:43
✔ Best Answer
Your looking to Transpose

Highlight your row
Select Copy

Select an empty column
Place your cursor in the first cell
Select: Paste / Special / Transpose

MIKE

http://www.skeptic.com/


Report •

#2
October 8, 2011 at 17:52:32
Thank you!

I was trying to cut and paste; to reveal the transpose option, you have to copy and paste.


Report •

Related Solutions


Ask Question