Hi everyone,
I've got this problem I'm not sure how to approach, other than that I must use VBA to solve it (I guess).
So, with no prior experience with VBA, I ask you here.
The same part can have one or more rows, depending on the number of machines it belongs to.
If one part belongs to several machines, it has its own row.
I need this list to be altered to remove the duplicate rows, and add the additional machines in columns behind
the first machine.
This way I only get one line per part number, and have the machines listed progressively by adding columns to the line for the part.
Right now my workbook contains some 20000+ rows, and about 19000 of them are duplicates.
Column A = Part number
Column B = Quantity
Column C = Machine
BEFORE
A B C 1234 1 10 1324 0 11 1234 1 12
AFTER
NEW NEW A B C D E 1243 1 10 11 12
So basically:
- Find duplicate rows with the same part number
- Move value (col C) from the extra rows to D, E, F... in the first row.
- Add the total quantity number from range BX:BY to cell BX
- Delete the extra rows.
Can anyone help with this? It might be easy, but I'm completely new to VBA.
The attached Excel-file shows the entire data set, minus some columns not relevant for the processing.
Best regards,
Knut F. Henriksen
Norway
Bookmarks