Hi
I have multiple columns containing different values, p/n, description, price
qty...

p/n desc price A B C D
23 valve 1.00 1 1 1
32 pump 2.50 1 1 2
3 plc 6.75 1 1 1
45sd sw 9.00 1 1

Where A,B,C,D are the complete units, the numbers below are the total of
each item on the left in the unit. (ie. P/N A has 1 valve and 1 plc)

I need to be able to ref a part number and list ONLY every item on that unit.