I have a table with fields Full Name and Category. There are three categories (1,2,3)
Basically I want each name to be repeated each time to have a row with category 1 another with 2 and another with 3 like below.
Full Name | Category |
John Smith | 1 |
John Smith | 2 |
John Smith | 3 |
Serena Tang | 1 |
Serena Tang | 2 |
Serena Tang | 3 |
The only thing is some people in the column already have three rows while some only have two (for category 1 and 2).
So I want a condition that says if the value in [Full Name] does not have 3 in [Category] then create a new row with the Full Name and Category = 3 (with all the other columns I have in the table remaining blank)
How can I go about doing this?
Thanks!
Solved! Go to Solution.
Hi @Serena3 ,
maybe a solution is to generate all rows needed for each name and add the previously non-existing rows to your table:
I attached a sample workflow. Does this help?
Best regards
Roland
Brilliant! This does the trick, thank you so much!
Awesome thanks!