Transposing an Array of data into a single column in Excel
by jladen
In reply to
Transposing an Array of d ...
Transposing an Array of data into a single column in Excel
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.