I have a spreadsheet example below:

Device Name App Owner
King 123 Brown
Queen 567 Orange
Bishop 789 Black
Knight 765 Red
King 321 Purple
King 987 Brown
Knight 456 Red

Total 7


Device Name only should be listed once, and the multiple App & Mgr fileds need to be merged into one cell.
Need it to look like this:

Device Name App Owner
King 123, 321,987 Brown, Purple
Queen 567 Orange
Bishop 789 Black
Knight 765, 456 Red

Total 4

Thanks in advance!!!!