I need some help in sorting my data. As in the image, the original file looks like the top image and I want to split the size into a new row below for all items as in the bottom image.
The file contains multiple columns that look like this. All content are separated with comma. I want to split these data into a new row under the original item for 1000 items per page. Either function or VBa will be really helpful .
I am using Excel 2016 .