Hello,
Having trouble figuring out how to merge rows together into one since the additional lines are empty except for the address column. Example imaged below:
What I have now:
What it should look like:
Thank you in advance,
Kim
Solved! Go to Solution.
Hi @kas
There are lots of ways to go about this. As you've a lot of fields that require this logic, i'd probably transpose the data first, so I can then just use a single MultiRow Formula tool, as is shown below and attached.
Hope that helps,
Andy
Hi @kas I mocked up a workflow that produces your output let me know what you think?
Hi @kas,
You could also use a multi-row to flag groups of rows and then a summarise tool to combine all your fields as below:
@OllieClarke Perfect...short and sweet and does the trick...thank you!
Thank you everyone for your help, all great solutions!
Much appreciate this community!
Kim
This one is a total winner. Thanks!