Hi All
I have a list of part no's with various prices and I need a formula that can do the following

Part No Lowest Price Next Price Next Price Next Price ........ until Max price.

PHAE150007 5 5.79 6.72 8.85
PHAE150012 5.57 6.63 7.95 8.00 9.00

Any one got any clues

Pivot table too big.

Kindest regards