Hi,

I have been able to get a visualforce page working to display the results of a query with one row for each record but would like to see if it is possible to format the data differently so that I can group by a field and then display all of the values in another field in the rest of the row. An example would be:

FIELD 1      FIELD 2         FIELD 3
A                 1                     Red
A                 2                     Yellow
B                 2                      Yellow
B                 1                      Red
B                 3                      Green

To be displayed in separate cells as:

A      1(in red)        2(in yellow)
B      2(in yellow)    1(in red)        3(in green) 

Thanks in advance for any assistance.

Hi,

I have been able to get a visualforce page working to display the results of a query with one row for each record but would like to see if it is possible to format the data differently so that I can group by a field and then display all of the values in another field in the rest of the row. An example would be:

FIELD 1      FIELD 2         FIELD 3
A                 1                     Red
A                 2                     Yellow
B                 2                      Yellow
B                 1                      Red
B                 3                      Green

To be displayed in separate cells as:

A      1(in red)        2(in yellow)
B      2(in yellow)    1(in red)        3(in green) 

Thanks in advance for any assistance.