Product matrix sorting

[nparsons75]

I have a product matrix which is basically a list or part numbers in column A.

Accross the top of comuns B to T for example are headers.

Rows A to Z contain part numbers.

An X is placed in the cells to show which part numbers assign to each header.

So Part 1 may be assigned to Column B, C, D and G

Part 2 may be assigned to Column C, E and F

Is there away of sorting the rows so that all the ones that are assigned to header which are the same are grouped together?

Hope that makes sense?

 

[azumi]

Yep maybe it could be done, but hard without seeing your sample workbook and your desired results too

Thanks

 

[nparsons75]

Hi please see example link.

I need to group together all parts that go through the same ops, or as closely as possible, usually within 80% of each other as a guide.

https://www.dropbox.com/s/fmwcdnz3j6vhl3t/MATRIX.xlsm?dl=0

 

[azumi]

I see the file, but still not clear, Is that in Sheet2 is the results that you try to acieve?