Hello,
I am a beginner in Excel Macros. I need to transpose first 8 cells in a column into a row, then the next 8 cells in the column into second row and so on for a total of 9224 cells (after conversion 1152 rows).
I referred the following thread and after trying my best for 2 hours to customize the macro given there, I could not get the output I wanted.
http://www.excelforum.com/excel-prog...s-to-rows.html
An example excel sheet of the output required is attached. Would be grateful for any kind of help!!
Thank you.
Bookmarks