Combining Columns into Row

[prernaaher]

Hello Everyone,

I am trying to get all passengers into one row.

Data:

Expectation: 

I tried summarize tool but could not achieve the result. I would really appreciate some help with this.

Thank you.

[ShankerV]

Hi @prernaaher 

Please use the multi row formula, where you number as  1, 2, 3 and if the value is null then Previous row value.

this will create a column 

1

2

3

3

3

4

4

4

Then please perform the concat using summarize tool to get the desired output.

Many thanks

Shanker V

[prernaaher]

@ShankerV 

Could you please help me with an example workflow. Thank you :)

[ShankerV]

Hi @prernaaher 

Please find the below expected output.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @prernaaher 

Step 1: Input

Step 2: Multi row formula

Step 3: Summarize tool

Step 4: Join tool

Result:

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[binuacs]

@prernaaher One way of doing this

[prernaaher]

Thank you!! This worked as well