Transpose field contents to field labels

[bengrech]

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!

[aducom]

As long as the fields do not need to be updated you can consider using an event to fill a label containing the <table> instructions and display the label?

[jsbinca]

If you are using MySQL you really should have a look at the GROUP_CONCAT() function.

jsb