Flex Advanced Data Grid display hierarchical tree using flat data?

Question

Is it possible to build a hierarchical advanced data grid (or similar) without using hierarchical data pre-built?

For example, if I want to show in the advanced data grid (or similar):

Men John Frank

Women Mary Susan Sally

But my data looks like this (2 fields):

John Men Mary Women Frank Men Susan Women Sally Women

So basically I want to take flat data, group it by Men/Women and then display a hierarchical advanced data grid by that grouping (or hopefully more than one grouping / tree).

??

Answer 1

Take a look at GroupingCollection. If you are using Flex 4+ you should use GroupingCollection2 instead.