Create new rows based on cells condition

[elfunambolo]

Hello everyone,
I would like to add new rows based on the values of cells S to AD (Size1-> 12).

In detail, I have to check if the value of these cells is different from 0 and in this case create as many rows as there are cells with values other than 0 (and insert the original value in the cell).

I attach example of the AS IS and TO BE of the first line.

Thanks for your precious help,
Giovanni

[chukleswk]

This is a down and dirty quick way in which to do what you are looking for. You can remove the filter at the front and it will run for all of the data.

[elfunambolo]

I tried to remove the filter but the output is not fine because I see only first column (Size 1) filled...

[elfunambolo]

This is the dataset (AS IS sheet)

[chukleswk · Accepted solution]

That's because the data is unsorted and it's pulling in the size 1 column first in the union. I added a sort that orders it by the order number and line number so that you can see all of the sizes.