How to group data based on location in a datatable?

I’m having a datatable that has location column like

Chennai
Mumbai
Coimbatore
HQ - Chennai
HQ - Mumbai

I want to group these but, I want all the HQ to be as one. How to achieve this?

@cybzom,

Do you mean to group chennai and HQ - Chennai as a single location called Chennai?

Hi ,

Check this activity.

Regards
Balamurugan.S

No, group only the HQ’s together @sarathi125

Sir, I appreciate your post but I cannot use custom activities by 3rd parties only uiptah activities are allowed in my project… so pls suggest me a way around this…

thnx…