We import our woocommerce orders into Google Sheets. Each order has their own row with select data. However, I would like to separate an order that has more than one type of product into its own row.
Right now, it combines them into the same row with this format:
Order # Product Name QTY Unit Price Item Total
123 Can A, Can B 2,1 $5, $3 $10, $3
I need it to look like this:
Order # Product Name QTY Unit Price Item Total
123 Can A 2 $5 $10
123 Can B 1 $3 $3
I appreciate any help!
