Rearrange multiple columns in four columns, VBA [Solved]

Posts
1
Registration date
Saturday February 3, 2018
Last seen
February 3, 2018
- Feb 3, 2018 at 05:35 AM - Latest reply:
Posts
10861
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
November 17, 2018
- 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 

Your reply

1 reply

Posts
10861
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
November 17, 2018
- Updated by ac3mark on 5/02/18 at 04:51 PM
0
Thank you
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