How to add grouping in straight table

[Sunil]

I have data like below in straight table.

ID     Plant

10    A

10    B

10    C

20    A

20    B

20    C 

I would like to make group by ID as shown below

ID     Plant

          A

10     B

           A

20      B

           C

Can anyone please suggest

Spoiler

Spoiler

[agigliotti]

what about using pivot table instead?

[Vegar]

What are you trying to accomplish? Is there a reason why you can not use a pivot table?

[Sunil]

Basically I am using Simple table extension, the reason using this extension is I have to show image in table as well. 

[Vegar]

So your question is on how to get the desired output in a table generated by the Simple  table extension?

[Sunil]

Yes,

My requirement is I have to show all functionality as give below in same table.

1. Need to show image based on expression
2. Need to apply conditional color logic for selected coloum
3.  Need to group by Dimension rather than repeating same value in multiple rows.

Thanks,

[tomovangel]

Hi Sunil, 

Can you try this as dimension maybe it will work for you

Aggr( Only(ID),Plant)