I have a spreadsheet with products that need to be associated to any variants that belong to the parent sku. I have a column with “type” and each row will have either “parent” or “size” in that column. I’m trying to figure out how select a parent row, and any following rows that say size. Then I can work with that data and loop back to get the next parent/size collection of data.
Cleanest way would probably to use a bit of code to fix it.
But a no code solution should also be possible just a bit of a head scratcher on how to do it.
Do you have some sample data we can use to get you an example?