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!
See attached. I put an example in Sheet 1 and the new table in Sheet 2. hth.
Thank you very much indeed! You saved me a lot of work!
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!
Hi,
Just change the references to column G to O in the formulas.
this in cell A3, copied down
this in cell B2, copied downCode:=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))
=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)
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks