So I have an SOQL query which returns an object with these fields:
Category could be: A B
Options could be: 1 2 3
In my VisualForce page I would like to visualise that in this form:
That would be something like apex:repeat and then group by Category first, then by Option and finally display Name under that. The thing is that there could be multiple entries of Category A and B, while I would only like to display the Category name once and distribute Product Names accordingly. Situation with Option field is the same as with Category.
I would appreciate your help