SOLVED
Combining columns by another columns data in excel
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
tapanrastogi
5 - Atom
‎05-15-2022
08:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Labels:
- Labels:
- Alteryx Practice
1 REPLY 1
17 - Castor
‎05-15-2022
08:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can just use a summarise tool for this! I have attached the workflow for your desired outcome. I've used \n as the separator when concatenating as that achieves your desired output, but you could equally just concatenate them using a comma or something so the groupings would sit on one line (shown in the second screenshot).
