Formatting

[outlet.ee]

I need to export products into another shop, now the attributes are as follows:

code size qty size qty size qty
3456 M 5 L 5 XL 5

In the new shop it should be, each on different row:

code size qty
3456 M 5
3456 L 5
3456 XL 5

Is there any way doing it automatically to avoid doing it 1 by one? Thanks for you help!

[darkyam]

See attached. I put an example in Sheet 1 and the new table in Sheet 2. hth.

[outlet.ee]

Thank you very much indeed! You saved me a lot of work!

[outlet.ee]

Hello again. I can't figure out how to make it that it will fetch data from sheet 1 till column O (now it is till column G). Would you like to fix this? Thank you!

[teylyn]

Hi,

Just change the references to column G to O in the formulas.

this in cell A3, copied down

=IF(COUNT(INDEX(Sheet1!$B:$B,MATCH(A2,Sheet1!$A:$A,0)):INDEX(Sheet1!$O:$O,MATCH(A2,Sheet1!$A:$A,0)))>COUNTIF($A$1:$A2,A2),A2,INDEX(Sheet1!$A:$A,MATCH(A2,Sheet1!$A:$A,0)+1))

this in cell B2, copied down

=INDEX(Sheet1!$A:$O,MATCH($A2,Sheet1!A:A,0),COUNTIF($A$2:$A2,$A2)*2)

this in cell C2, copied down

=INDEX(Sheet1!$A:$O,MATCH($A2,Sheet1!A:A,0),COUNTIF($A$2:$A2,$A2)*2+1)