topic Re: Combining Columns into Row in Alteryx Designer Desktop Discussions

Combining Columns into Row

prernaaher — Wed, 04 Jan 2023 19:40:32 GMT

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 — Wed, 04 Jan 2023 19:45:49 GMT

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

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

Many thanks

Shanker V

prernaaher — Wed, 04 Jan 2023 20:15:58 GMT

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

ShankerV — Wed, 04 Jan 2023 20:30:06 GMT

Please find the below expected output.

Many thanks

Shanker V

ShankerV — Wed, 04 Jan 2023 20:34:40 GMT

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

binu_acs — Wed, 04 Jan 2023 22:16:05 GMT

@prernaaher One way of doing this

prernaaher — Wed, 11 Jan 2023 19:40:50 GMT

Thank you!! This worked as well