Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
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