Hi,

I have a table which data is organized as follows,

Style                        Color  Size_Qty
MEW6SQ215        101     XS,12; S,12; M,10;
MZ10E727L           360     29,2;30,4;31,6;32,4;33,2;
M002U2402           387     S,34; M,54; L,35;XL,17;
M002D6502           100     XS,137; S,502; M,499; L,212;

How can I using a query to form the record as following
Style                        Color  Size    Qty
MEW6SQ215        101     XS       12
MEW6SQ215        101        S       12
MEW6SQ215        101        M       10
MZ10E727L           360       29        2
MZ10E727L           360       30        4
.
.
.
.

Thank you.