Forum Discussion

MichaelRensing's avatar
MichaelRensing
Helper I
3 years ago

Group data by certain values in a column

I have a table of data. One of the columns contains a number + letter combination to identify the item.  Like 1A, 1B, 1C, 2A, 2B, 2C, M1A, C1A, etc.  I would like to create a grouping of the rows tha...
Need Help
mytnikk's avatar
mytnikk
New Member
2 years ago

Hi, 

 

You can create conditional forum that will transform source IDs into Groups. 

 

 

Sample conditions: 

If ID column equals "1A" then "Group 1"  

If ID column equals "1B" then "Group 1"  

If ID column equals "2A" then "Group 1"  

If ID column equals "2B" then "Group 1"  

 

After that you will be able to GroupBy on New Group column. Hope it helps.