Full disclosure: I'm a total VB novice. But I'm learning and could really use some help creating a macro in excel. I've been working on this for 2 days now and can't seem to figure out the right approach. Basically, I need to move the data from multiple rows with vertical data to one row with multiple columns sorted horizontally. Here is the breakdown:
- Condense multiple rows of data with a matching "GroupNumber" - deleting the extra rows once the data is consolidated with the first row.
- Consolidate all the vertical data from each cell in Column C (T-CarrierHealth_1.Carrier) with the same "GroupNumber" into the 1st row with the "GroupNumber".
- Sort the data into new columns based on the carrier name from column C (T-CarrierHealth_1.Carrier).
For example: Here is the spreadsheet that I begin with:
And here is what I am trying to achieve:
Can anyone help me figure out the best method for this? I may need to manipulate the macro each month so I really want to understand the method behind it all. If anyone can help, I'd appreciate it greatly.