Hello, I am trying to convert some data currently exported as below:
<tbody>
</tbody>
We need this transformed in excel into something like the below:
<tbody>
</tbody>
Any help would be greatly appreciated!
Thanks!
Order Number | SKU | Price |
Order1 | sku1,sku2 | $1,$2 |
Order2 | sku3,sku4 | $1,$2 |
<tbody>
</tbody>
We need this transformed in excel into something like the below:
Order Number | SKU | Price |
Order1 | sku1 | $1 |
Order1 | sku2 | $2 |
Order2 | sku3 | $1 |
Order2 | sku4 | $2 |
<tbody>
</tbody>
Any help would be greatly appreciated!
Thanks!