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!!