Grouping Values in New Columns based on Other Column

[ERichard]

I have an extract of Learning Assignments, listed by emails.

This is an example of what the data looks like:

I'm trying to group the data by the email, and have an individual column for the learning assigned, but not by the value - just by the count of learning assignments, and in no particular order:

Thanks for your help!

[Anonymous]

Hi @ERichard ,

I wanted to check if you had the opportunity to review the information provided by @SundarRaj . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[SundarRaj · Accepted solution]

Hi @ERichard, here's a solution you could use to solve your query. Take a look. I'll leave the images of the code, source table and output below. Thanks

[ERichard]

Thanks! This worked great!