Jun 23 2022 03:23 PM
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?
Chainrings | Collection:, Mount: DM, NewB2B, Product Type: Chainrings, Size: 50T, System: 1X, Vendor: Easton Cycling |
Bolts | NewB2B, Product: Chainrings, Small Parts |
Chainrings | Collection:, Mount: 4 BOLT, NewB2B, Product Type: Chainrings, Size: 53T, System: 11SPD, Vendor: Easton Cycling |
Chainrings | Collection:, Mount: 4 BOLT, NewB2B, Product Type: Chainrings, Size: 39T, System: 11SPD, Vendor: Easton Cycling |
Chainrings | Collection:, Mount: 4 BOLT, NewB2B, Product Type: Chainrings, Size: 52T, System: 11SPD, Vendor: Easton Cycling |
Chainrings | Collection:, Mount: 4 BOLT, NewB2B, Product Type: Chainrings, Size: 36T, System: 11SPD, Vendor: Easton Cycling |
Chainrings | Collection:, Mount: 4 BOLT, NewB2B, Product Type: Chainrings, Size: 50T, System: 11SPD, Vendor: Easton Cycling |
Chainrings | Collection:, Mount: 4 BOLT, NewB2B, Product Type: Chainrings, Size: 34T, System: 11SPD, Vendor: Easton Cycling |
Handlebars | Clamp Diameter: 31.8, Collection: EC70 SL, Di2 Compatible: Yes, Drop Angle: 4°, NewB2B, Product: Handlebar, Width (cm): 40 |
Handlebars | Clamp Diameter: 31.8, Collection: EC70 SL, Di2 Compatible: Yes, Drop Angle: 4°, NewB2B, Product: Handlebar, Width (cm): 42 |
Handlebars | Clamp Diameter: 31.8, Collection: EC70 SL, Di2 Compatible: Yes, Drop Angle: 4°, NewB2B, Product: Handlebar, Width (cm): 44 |
Handlebars | Clamp Diameter: 31.8, Collection: EC70 SL, Di2 Compatible: Yes, Drop Angle: 4°, NewB2B, Product: Handlebar, Width (cm): 46 |