Hi There
I have a list of part numbers and cross references displayed in 3 columns.
A - Supplier Code B - Supplier Part Number C - Our Part Number
SUP1 1234 E5654
SUP1 4321 E5654
SUP2 1111 E5654
SUP3 0125 E2222
SUP1 5555 E2222
I need to format the data so that there is 1 line per Our part number (from column C) and have the supplier code as columns eg.
A- Our Part Number B - SUP1 C- SUP1 D-SUP2 E-SUP3
E5654 1234 4321 1111
E2222 5555 0125
Any ideas how this can be achieved easily ? There are around 6000 rows on the spreadsheet.
Bookmarks