I have an excel file which I'll use to import hundreds of products in an e-shop. The excel have columns like this
Title | SKU | Size | Price | etc
I asked my clients to make the excel in very specific format (especially on rows). I wanted each variation of the product (size) to has its own row. Lets say for a shirt which has 3 sizes (S, M, L), it should have 3 rows for each variation. Well, they sent me the excel with the variations to be in one row, like this
I'm totally noob on Excel. How can I make a macro lets say, to check for the variations which are seperated by the slash and make x number of duplicated rows? And also if (that would make me veeeery happy) can keep only one variation in each row.
Thank you :)