nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Grouping

BAIG · 2009-11-23T15:26:40+00:00

Hello, I have the following columns in the table which I need to display as single column and grouped by role. Role1 , Role2 , Role3, membername Example data. Systems Analyst , Operations support, Member1 …

BAIG

Hello, 
 
I have the following columns in the table which I need to display as single column and grouped by role. 
 
Role1 , Role2 , Role3, membername 
 
Example data. 
 
Systems Analyst , Operations support, Member1 
Operations support Member2 
Project Engineer, Systems Analyst Member3 
 
 
Desired output 
Systems analyst Member1 
member3 
 
Operations support Member1 
Member2 
 
Project Engineer Member3

Find more posts tagged with

Comments

mwilliams

Hi BAIG,

The roles being in different columns may create an issue here. If you knew all the possible roles and could make a dataSet with those in a field, you could possibly use a set of joins to get the roles all in one column. I'll have to think about it to see if there's an easier way I can think of.

BAIG

Thanks Michael for the quick reply. Could you please tell how to achieve your suggestion, that's bringing all the roles in one column using join.

Thanks.