Pivot in Save search
I created a saved search that generates a price list for our customers. For each sku we have 3 records:
1. base price from the parent sku
2.base price from child A ( for custom over a specific size).
2.base price from child B ( for custom under a specific size).
SKU SIZE PRICE
2118. small/large $10
2118. custom A $20
2118. cusomb b $30
Is there any way I can Pivot the data so the output will be like this :
SKU SIZE PRICE. price A. price B
2118. small,large. $10. $20 $30
Thanks in advance.