Forum Discussion

symun123's avatar
symun123
New Member
2 years ago
Solved

Group mulitple rows into one

I am wanting to group data from one column into distinct rows from another column, is this possible? I have tried the 'Group By' function but it doesn't seem to do what I want.

Here is a screenshot, you can see 'Issue' has multiple rows because the License column has seperated. What I want is one row for issue PCR-466 with all license grouped together in the same row. Is this possible?

 

Need Help

6 Replies

    • symun123's avatar
      symun123
      New Member
      2 years ago

      Thanks, got that working.
      Next question if you could help again, instead of listing the licenses as a comma seperated list, is there a way to replace them with the word 'Global'? Tried Text.Replace but that didnt work

      • Uzi2019's avatar
        Uzi2019
        Community Champion
        2 years ago

        Hi symun123 

        just simply in your code use "Global" instead of ",".

         

         

         

        I hope I answered your question!