Hi,
I'm working in the fashion business
I have a large database with data at style level (gender, product type, price...) and quantities size by size (s, m, l, xl)
Typical data would be:
women, sweater, $30.00, 0, 10, 15, 13, 6, 0, 0 for the following column headers:
gender, product_type, price, size_xs, size_s, size_m, size_l, size_xl, size_xxl, size_xxxl
I would like to have one row for each size, excluding sizes with 0 units, and mentioning the appropriate size header
This would look like that
women, sweater, $30.00, size_s, 10
women, sweater, $30.00, size_m, 15
women, sweater, $30.00, size_l, 13
women, sweater, $30.00, size_xl, 6
Can anyone help?
Thanks a lot!!!
I'm working in the fashion business

I have a large database with data at style level (gender, product type, price...) and quantities size by size (s, m, l, xl)
Typical data would be:
women, sweater, $30.00, 0, 10, 15, 13, 6, 0, 0 for the following column headers:
gender, product_type, price, size_xs, size_s, size_m, size_l, size_xl, size_xxl, size_xxxl
I would like to have one row for each size, excluding sizes with 0 units, and mentioning the appropriate size header
This would look like that
women, sweater, $30.00, size_s, 10
women, sweater, $30.00, size_m, 15
women, sweater, $30.00, size_l, 13
women, sweater, $30.00, size_xl, 6
Can anyone help?

Thanks a lot!!!