Complex sort in excel

New Contributor

Hi, I'm in need of assistance to figure out my sorting issues. 

 

I have a spreadsheet, with comma delimited information in one cell. I have performed a text to column for this data set. My issue is that the Comma delimited information was not input in the same order for each row, so while I have overlapping values they are not in the same column. I need to organize all the like values by column while preserving the row. 

I have attached a screen shot below. in this case I'd like to get all the Colon Delimited cells into the same column. 

 

What is the reccomended way to go about this? Am I going to have to make some xlookup with the values I want as headers?

 

 

 

ChainringsCollection:, Mount: DM, NewB2B, Product Type: Chainrings, Size: 50T, System: 1X, Vendor: Easton Cycling
BoltsNewB2B, Product: Chainrings, Small Parts
ChainringsCollection:, Mount: 4 BOLT, NewB2B, Product Type: Chainrings, Size: 53T, System: 11SPD, Vendor: Easton Cycling
ChainringsCollection:, Mount: 4 BOLT, NewB2B, Product Type: Chainrings, Size: 39T, System: 11SPD, Vendor: Easton Cycling
ChainringsCollection:, Mount: 4 BOLT, NewB2B, Product Type: Chainrings, Size: 52T, System: 11SPD, Vendor: Easton Cycling
ChainringsCollection:, Mount: 4 BOLT, NewB2B, Product Type: Chainrings, Size: 36T, System: 11SPD, Vendor: Easton Cycling
ChainringsCollection:, Mount: 4 BOLT, NewB2B, Product Type: Chainrings, Size: 50T, System: 11SPD, Vendor: Easton Cycling
ChainringsCollection:, Mount: 4 BOLT, NewB2B, Product Type: Chainrings, Size: 34T, System: 11SPD, Vendor: Easton Cycling
HandlebarsClamp Diameter: 31.8, Collection: EC70 SL, Di2 Compatible: Yes, Drop Angle: 4°, NewB2B, Product: Handlebar, Width (cm): 40
HandlebarsClamp Diameter: 31.8, Collection: EC70 SL, Di2 Compatible: Yes, Drop Angle: 4°, NewB2B, Product: Handlebar, Width (cm): 42
HandlebarsClamp Diameter: 31.8, Collection: EC70 SL, Di2 Compatible: Yes, Drop Angle: 4°, NewB2B, Product: Handlebar, Width (cm): 44
HandlebarsClamp Diameter: 31.8, Collection: EC70 SL, Di2 Compatible: Yes, Drop Angle: 4°, NewB2B, Product: Handlebar, Width (cm): 46
0 Replies