Rearrange multiple columns in four columns, VBA

Solved/Closed
eguzun Posts 1 Registration date Saturday February 3, 2018 Status Member Last seen February 3, 2018 - Updated on Feb 3, 2018 at 08:10 AM
 Blocked Profile - Feb 5, 2018 at 04:51 PM
Hello guys,
An excel rookie needs the help of more experienced users of Excel and VBA.

I have a data set that looks the following way:


There are around 600 companies in the data set. I would like to arrange those companies and their four columns of data into only four columns. In other words, I want all the data to be arranged only in columns A-D, no data starting from column E. Note: the amount of data for each company differs; I can have 10 years of data for one company, and only 2 months of data for another company.

I look forward to hearing from you soon. Thank you so much in advance!

1 response

Take your mouse, and highlight the columns you wish to have deleted, and press delete! VIOLA!

We are volunteers, who help when you are stuck with your solutions. Right now, we have given you a SIMPLE solution for your issue. If you are having issues with your CODE, then please post it so that we can see what the issue may be. If you have no code, please understand we do not write a turn key solution for users.

0