Hi
I have a spreadsheet full of product SKU's. The sku is the style of shoe and tacked on the end is -n where n is the size of shoe.
I'd like to have a new column that shows all of the shoe sizes available for a particular shoe style in a comma separated list but I have no idea how to do this. There are lots of shoe styles and sizes to choose from.
My spreadsheet is formatted so that the shoe style is listed above the available shoe sizes. The attached image helps to explain what I am after.shoes.png
Thanks
Bookmarks