If I have a result with the following in three separate rows from a database:
PriceGroup: 0
Price: 1.20
PriceGroup: 1
Price: 2.30
PriceGroup: 2
Price: 3.00
Is it possible to transpose these such that I could create a grid to display something as follows:
Price Group 0 Price Group 1 Price Group 2
========== ========== ==========
1.20 2.30 3.00
Any help would be appreciated!