DesioMedia
New Member
- Joined
- Jun 10, 2019
- Messages
- 1
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 achieve this reorganization.
Thanks so much!
Original Format ("Google Doc" Sheet):
<a href="https://ibb.co/6rvSbx2"><img src="https://i.ibb.co/6rvSbx2/Screen-Shot-2019-06-06-at-6-23-52-PM.png" alt="Screen-Shot-2019-06-06-at-6-23-52-PM" border="0"></a>
Desired Format ("Shopify Format" Sheet):
<a href="https://ibb.co/Xt4LKS7"><img src="https://i.ibb.co/Xt4LKS7/Screen-Shot-2019-06-06-at-6-25-26-PM.png" alt="Screen-Shot-2019-06-06-at-6-25-26-PM" border="0"></a>
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 achieve this reorganization.
Thanks so much!
Original Format ("Google Doc" Sheet):
<a href="https://ibb.co/6rvSbx2"><img src="https://i.ibb.co/6rvSbx2/Screen-Shot-2019-06-06-at-6-23-52-PM.png" alt="Screen-Shot-2019-06-06-at-6-23-52-PM" border="0"></a>
Desired Format ("Shopify Format" Sheet):
<a href="https://ibb.co/Xt4LKS7"><img src="https://i.ibb.co/Xt4LKS7/Screen-Shot-2019-06-06-at-6-25-26-PM.png" alt="Screen-Shot-2019-06-06-at-6-25-26-PM" border="0"></a>