Rearrange multiple columns in four columns, VBA [Solved/Closed]

Report
Posts
1
Registration date
Saturday February 3, 2018
Status
Member
Last seen
February 3, 2018
-
ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
-
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!
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1573
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.