Hi,

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.

K