convert columns into rows

[RayK]

I have a a single row with multiple columns of data.



How do I turn it into a single column with multiple rows?

[xor]

If you have your data in row 1:

=INDEX($1:$1,,ROWS($1:1))

[RayK]

Originally Posted by xor

If you have your data in row 1:

=INDEX($1:$1,,ROWS($1:1))

Thank you. That worked perfectly.