I have table with 2 columns and 4 rows. colA is unique. ColB values are same for each of 2 rows.
Here is the actual data in table

ColA ColB
-----------------------
1 PRODUCT
2 PRODUCT
3 PRICE
4 PRICE

I am trying to get output from a single query as below.

1,2 -- PRODUCT
3,4 -- PRICE

Can someone please advise how to write this query.