#1
|
|||
|
|||
convert columns into rows
I have a a single row with multiple columns of data.
How do I turn it into a single column with multiple rows? |
#2
|
|||
|
|||
If you have your data in row 1:
=INDEX($1:$1,,ROWS($1:1)) |
#3
|
|||
|
|||
Thank you. That worked perfectly.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Rows to Columns with Every Other Row Formula | dlucius | Excel | 1 | 12-21-2015 07:10 PM |
Moving from Rows to Columns | jimmydd2121 | Excel | 1 | 06-02-2014 09:05 AM |
Stack columns into rows | stellag09 | Excel | 1 | 04-23-2014 03:26 AM |
Changing rows into columns | paapachak | Word Tables | 8 | 01-06-2014 02:44 PM |
Rows to Columns | kyakobi | Excel | 5 | 12-07-2010 03:12 PM |