Rearrange multiple columns in four columns, VBA [Solved]

eguzun 1 Posts Saturday February 3, 2018Registration date February 3, 2018 Last seen - Feb 3, 2018 at 05:35 AM - Latest reply: ac3mark 8826 Posts Monday June 3, 2013Registration dateModeratorStatus February 21, 2018 Last seen
- 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!
See more 

1 reply

Reply to this topic
ac3mark 8826 Posts Monday June 3, 2013Registration dateModeratorStatus February 21, 2018 Last seen - Updated by ac3mark on 5/02/18 at 04:51 PM
0
Helpful
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.

Respond to ac3mark