Sorting and grouping identical BOMs

[dirtychinchilla]

Morning all,

One of my colleagues has come to me with a huge list, which contains various bill of materials (BOMs), some of which are identical, but all of which are uniquely labelled. We can't change the software that they're using, so we have to adjust the output afterwards.

I've uploaded the sort of spreadsheet he receives to the following link:

https://docs.google.com/spreadsheets/d/1vta0nOI2HXdUX4YWL-jXogW4J4Y49UNMSjNCa_fgy5w/edit?usp=sharing

The label is in Row 1, and the parts list is in column A.

So to my question, is there any way to sort all these so that he can have a list of unique parts lists, with a list of which labels (Row 1) these fall into?

Any guidance would be massively appreciated as he spends hours sorting this data out!

Thanks in advance,

dirtychinchilla