Column Data Merging & Unmerging

SammySpaceman

Board Regular
Joined
Aug 18, 2002
Messages
57
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.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Forum statistics

Threads
1,143,615
Messages
5,719,725
Members
422,242
Latest member
hishamkhatri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top