Hi,
I have multiple tables that contains the same 3 column headings , Site, Part, and Customer. I can't do this manually as the list is in the thousands and exceeds Excel capacity...see below for what I would like to happen
Table 1
Site Part Customer
Site 1 Part 1 Customer 1
Site 1 Part 2 Customer 1
Site 2 Part 3 Customer 1
Site 3 Part 4 Customer 1
Site 3 Part 5 Customer 1
Table 2
Site Part Customer
Site 1 Part 1 Customer 2
Site 1 Part 2 Customer 2
Site 2 Part 6 Customer 2
Site 3 Part 4 Customer 2
Site 3 Part 5 Customer 2
I want it to become
Site Part Customer
Site 1 Part 1 Customer 1, Customer 2
Site 1 Part 2 Customer 1, Customer 2
Site 2 Part 3 Customer 1
Site 2 Part 6 Customer 2
Site 3 Part 4 Customer 1, Customer 2
Site 4 Part 5 Customer 1, Customer 2
What's the SQL code that would do that? I can't upload the database for some reason, might not be allowed
Thank you!!
Bookmarks