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.
Solved! Go to Solution.
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
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
Thank you!! This worked as well