How to consolidate information from one table into a different view

I have an issue in that I have the following information in a table:

Store    UPC        Block       iNumber
002       12345      0124       01
002       23456      0124       02
002       12345      0227       03

As you can see, the product '12345' appears in the same store twice. What I need to do is have this information in a view by UPC location, so the result would be like this:

UPC         Block1    INumber1    Block2    iNumber2
12345       0124       01                0227       03

I need all the information about locations (Block/iNumber) in the same record.

Is this possible??

Thanks in advance.

Ken


Start Free Trial