Multiple rows to a single cell

[poornimak]

I have input from excel as below 

Name: Alex

Branch Name: qwerty

ID: 1234567899

I am trying to achieve below:

Name: Alex Branch Name: qwerty ID: 1234567899

[ShankerV · Accepted solution]

Hi @poornimak 

One way of doing this.

Input was:

Many thanks

Shanker V

[Raj]

summarize tool is the best option to achieve it.