Stacking Loads of Data - VBA

[paularthur90]

Hi,

I was wondering if anyone could help me.

I have loads of data in bunches of every three columns. I need a macro to go through and stack them on top of each other so there is only three columns in total.

I have attached an image showing a small section of the data so you can understand.

Capture.PNG

I would appreciate any help.

Thanks,
Paul

[Norie]

Perhaps.

Please Login or Register  to view this content.

[paularthur90]

Thank you so much this worked perfectly!!!

[JOHN H. DAVIS]

This creates a sheet called "Stack", which will have all the columns of three stacked.

Please Login or Register  to view this content.