How to Wrap Data to Multiple Columns in Excel
April 19, 2018 - by Bill Jelen
Gwynne has 15 thousand rows of data in three columns. She would like to have the data print with 6 columns per page. For example, the first 50 names in A2:C51, then the next 50 names in E2:G51. Then move the third 50 rows to A52:C101 and so on.
Rather than solve this with formulas, I am going to use a little Excel VBA to re-arrange the data.
The VBA macro will leave the data in A:C. A blank column will appear in D. The new data will appear in D:F, blank column in G, new data in H:J.
Almost 10 years ago, I answered a question on how to snake 1 column in to 6 columns. In the case, the data was arranged horizontally, with Apple in C1, Banana in D1, Cherry in E1, ... Fig in H1, then Guava starting in C2 and so on. Back then, I answered the question using formulas. You can watch that old video : here.
The first step is to figure out how many rows fit on your printed page. Do not skip this step. Before you start with the macro, you need to do all of these things: