Merging multiple rows

[kas]

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

[andyuttley]

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 

[JosephSerpis]

Hi @kas I mocked up a workflow that produces your output let me know what you think? 

[geraldo]

Hi 

Follow another suggestion

[OllieClarke · Accepted solution]

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:

[kas]

@OllieClarke Perfect...short and sweet and does the trick...thank you!

[kas]

Thank you everyone for your help, all great solutions!

Much appreciate this community!

Kim

[Mitch_S]

This one is a total winner. Thanks!