Hello, I have a flow that starts with filter on an entity column and then run a set of formulas on the population to create a concat summary. I want the flow to loop through the entity column and run the set of formulas for each unique value in that column and then compile the summary so each output for each loop/run of actions is complied in a sheet.
Sample Input: (in the real data there's a lot more entities in multiple rows of info so I need a loop to filter on each entity and run the same set of actions)
Entity | Name | Profession | Home Country | Sports |
AM | Jack | Driver | Spain | soccer |
AM | Jane | Doctor | USA | tennis |
BF | Mike | Pilot | | Pool |
BF | Sam | Nurse | UK | Rugby |
Desired Output:
Entity | Concat |
AM | Jack,Driver,Spain,Soccer,Jane,Doctor,USA,tennis |
BF | Mike,Pilot, ,Pool, Sam, Nurse,UK,Rugby |