Merge two string rows

[Ronal_bal]

Hi,

I need to merge these two rows into one,

Attached the screenshot

Any help is appreciated

Thanks

[ShankerV]

Hi @Ronal_bal 

One way of doing this.

Many thanks

Shanker V

[Ronal_bal]

can you attach the workflow please @ShankerV 

[ShankerV · Accepted solution]

Hi @Ronal_bal 

Step 1: Input

Step 2: 

Step 3:

Step 4:

Many thanks

Shanker V

[acarter881]

Hello, @Ronal_bal.

Does this solution work for you? I've attached the workflow.

Second, alternative method:

[hlee36]

I used a multi-row formula for each column. 

Edit:

Added summary tool to display the concatenated row only.

[bethamsetty]