I have a list of data that I need to turn from vertical to horizontal... I would like to do it via VBA as I have about 40K lines. I need to have it combine all data for each number group with the same type, prod and G/NG code. So all that have the same type, Prod, G/NG and Number need to be in one column with all from the Code column in the row....
I attached a sample file as well.
For example
Starting with
Number|Type | Code |Prod |G/NG |
:----:|:----:|:----:|:----:|:----:|
440 AF 1234 S7 G
440 AF 7865 S7 G
440 NY 1235 S7 G
440 NY 4567 S7 G
41MM AF 1234 S7 G
41MM AF 1235 S7 NG
Should now look like:
Number|Type | Code1 | Code2| Prod |G/NG |
:----:|:----:|:----: |:----:|:-----:|:----:|
440 AF 1234 7865 S7 G
Bookmarks