Hi,
I have a list that contains 3 columns, Site, Part, and Customer. I can't do this manually as the list is in the thousands...see below for what I would like to happen
Site Part Customer
Site 1 Part 1 Customer 2
Site 1 Part 2 Customer 1
Site 1 Part 2 Customer 2
Site 2 Part 3 Customer 1
Site 2 Part 3 Customer 2
Site 3 Part 4 Customer 1
Site 4 Part 5 Customer 1
Site 4 Part 5 Customer 2
I want it to become
Site Part Customer
Site 1 Part 1 Customer 2
Site 1 Part 2 Customer 1, Customer 2
Site 2 Part 3 Customer 1, Customer 2
Site 3 Part 4 Customer 1
Site 4 Part 5 Customer 1, Customer 2
Thank you!!
Bookmarks