Hello. I hope you can help me, because I struggle with this one. I want to create two columns from my sample data. See attached the 'raw data' and the desired outcome.
Hi @Rik1983 ,
if the "person" rows are not indented, but the client rows are, it could be a solution to use indentation:
Let me know, if it works for you.
Best,
Roland
Hi @Rik1983,
here is a quick example to do this:
Output:
Workflow attached. Let me know what you think.
Best
Alex
Thanks for this! Too easy! However my sample date is unfortunately not the real life. The name of the persons are different. So the "contains person" will not work for me... Any other suggestions for this?
