Transposing an Array of data into a single column in Excel

By Shriks ·
I have a bunch of data which is spread into an Excel sheet spanning 24 columns and abut 1000 rows.
For each of the 1000 rows I need all the 24 columns to be transposed into rows.
I am currently using the Transpose function by manually selecting the destination 24 rows, inserting the transpose function, selecting the source rows and the CSE.

I am looking for help in automating this set of keystrokes either through a macro - the one I recorded did not help me much, or through some other combination of formulae.
In case you need a sample file, can share on email.
look forward to a quick response (in internet time) :)
many thanks

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums