I hope this is possible.
In my attached example sheet, there are 8 different styles (I highlighted each group of styles) based on the style number (column A)
Column I shows all the sizes each style comes in separated by semicolons, but I don't want all the sizes to appear in the same cell. It should only be one size per cell/line.
For each style, starting from the first (left most) size, make that size the only value in the cell. Then the next row, make the second size value the only value in the cell, etc., then repeat with the next style.
Then do the same with the quantity column.
Sheet1 is the original file. Sheet2 is how I ultimately want the data to look like after running the macro in sheet1
Can anyone do this?
Thanks!
Bookmarks