I have a sheet similar to the below data. Can we list out the unique names for each location? as shown in the below "desired output" section?
Location
Names
Location 1
Name 1, Name 2, Name 4
Location 1
Name 1, Name 4
Location 1
Name 2, Name 3, Name 5
Location 1
Name 1
Location 1...