I have a long list with a mix of unique part numbers and repeating part numbers. This is just an excerpt. The top half shows unique numbers, the bottom half shows numbers that repeat and the values. In my real data, the unique and repeating numbers are mixed randomly although the list is sorted from smallest part number to largest part number.
Root
Part
Number Unit Ship Amt
28763 $5,000
30763 $1,573
36051 $854
39496 $1,719
42364 $4,135
43511 $7,270
44439 $9,447
83508 $954
84290 $13
84290 $25
84290 $55
84290 $64
84291 $14
84291 $15
84291 $15
84291 $25
84292 $17
84292 $18
84292 $25
84292 $63
84292 $125
I want to convert it to look like this
Root
Part
Number Unit ship amount
28763 5,000
30763 1,573
36051 854
39496 1,719
42364 4,135
43511 7,270
44439 9,447
83508 954
84290 13 25 55 64
84291 14 15 15 25
84292 17 18 25 63 125
Basically, for the part numbers that have multiple values for ship amount, I want those ship amounts to appear in a separate, unique columns next to the part number instead of in a separate row like it does now. Any ideas?
Tom B.
Bookmarks