Column Data Merging & Unmerging

[SammySpaceman]

I have 2000 cells of data in column A. What I need to do is spread that data across multiple columns to print out on less sheets. However, I need to keep the data in order from top to bottom left to right. So let's say I can get 53 rows & up to Column J per sheet. What I've been doing is cutting from Column A Row 54 to Column A Row 2000 and pasting to Column B Row 1. Then I repeat the process with Column B to C and so on. After I've filled up Column J, I cut the data starting with Row 54 and paste it back to Column A Row 54. I repeat this process until the data is spread across throughout the sheets. Periodically, I need to put all of the data back into one column so I can enter additional pieces of data and re-sort. So I'm looking for a good way to automate the two processes. The total number of cell data can shift, depending on additions and any deletions. I know I can use a Macro, but I'm not sure how to set it up or if it's the best choice. Any information or help would be greatly appreciated.

 

[PaddyD]

download the asap addin from

http://www.asaputilities.com

it has a "Papersaver" option which splits columns for exactly that purpose (at least the first part).

paddy