Hi;
I have a table with the following columns:
Rpt
Line
Col
Txt

The table with values looks like this:

Rpt Line Col Txt
900 002 1 Main Street
901 002 1 Sub Street
900 002 2 #343
901 002 2 #546


I need to extract Street (Col with value 1), PO Box (Col with value 2) and the Rpt value
My output table should be something like this:

Rpt Street POBox
900 Main Street #343
901 Sub Street #546

How do I form the query.

Thanks in advance