Duplicating rows and entering values based on multiple column inputs

Hi All,

I have large data set of product SKU's that are organized with multiple sizes of the same item per row and need to break each sized item on to its own row with the correct corresponding size. I have attached screen shots for clarification. I'm really hoping you all can provide some assistance in method or formulas to achive this reorganization.

Thanks so much!

Original Format ("Google Doc" Sheet):
Screen Shot 2019-06-06 at 6.23.52 PM.png

Desired Format ("Shopify Format" Sheet):
Screen Shot 2019-06-06 at 6.25.26 PM.png

This proposal employs a helper column (A) which may be moved and/or hidden for aesthetic purposes.
A3:A20 are populated using: =COUNTIFS(B$3:B3,B3,C$3:C3,C3)
The formula for the style and color columns is: =IFERROR(INDEX(B$3:B$20,AGGREGATE(15,6,(ROW($A$3:$A$20)-ROW($A$2))/($A$3:$A$20=1),ROWS($A$1:$A1))),"")
The formula for size columns is:

Formula:

Please Login or Register  to view this content.

The formula for unit price is: =IF(B29="","",INDEX(K$3:K$20,AGGREGATE(15,6,(ROW(A$3:A$20)-ROW(A$2))/(B$3:B$20=B29)/(C$3:C$20=C29),1)))
The formula for total value is: =IF(B29="","",K29*M29)
The formula for total units is: =IF(B29="","",SUMIFS(M$3:M$20,B$3:B$20,B29,C$3:C$20,C29))
Let us know if you have any questions.