Hello,
I am looking for a way to arrange a set of rows into one long column. I have attached a JPEG of what I am working with. Specifically, I would like to create a column in this order: K2, L2, M2, N2, O2, K3, L3, M3, N3, O3, K4, L4, M4, N4, O4 ...... and so on. Is there a macro that can be written to perform this task?
Any help is greatly appreciated. Thank you in advance.
Excel.jpg
Bookmarks