I have an excel with two columns and 183137 rows. Column A is an Identifier for Column B.
On Page Break Preview it is set to 51 rows per page. How can I transpose the two columns into multiple columns?
E.G. Rows 1-51 is Columns A and B. Rows 52-101 is Columns C and D. Rows 102-152 is Columns E and F. etc.
Basically, I want to convert two extremely long columns into multiple columns so I can fit all the data onto less pages to print. Instead of a 3600+ pages with two columns, I would prefer 720 pages with 5 sets of the two columns. I can explain further if necessary.
Here is an Example.
Example.xlsm
Thank you for taking a look. Everyone on this forum is wonderful. I've learned a lot, though clearly not everything!
Bookmarks