I have a list of invoices some of them duplicates. The reason why they are duplicated is because each invoice may have multiple responsible parties. I am trying to come up with a way to have a list of unique invoice numbers in the first column and have the next column return the responsible parties.
Number Responsible Party Invoice Number Responsible Party
10002 traffic 10002 Traffic
10003 Sales 10003 Finance ,Sales, Operation
10005 Operations 10005 Operations, Traffic
Any help would be greatly appreciated