Crosstab is not doing it

Question

Hi all,

So I have a file that list entities name and expenses below in one column as follow:

I want it to be broken down in rows as follow:

I thought a crosstab would do it but it only take the values of the first line or last and concatenate won't work because there are number.

I would truly appreciate any help!

thanks

Felipe_Ribeir0 · Answer

Hi @AmAm

One way of doing this

transpose.yxmd

ShankerV · Answer

Hi @AmAm

Please let me know if you need a workflow to be build for the same.

If yes, please share the input in copy paste format, where it can be used for Alteryx input.

Thanks.

ShankerV · Answer

Hi @AmAm

To achieve the result, you need to filter the filename separately.

Then use the cross tab.

Then add Record ID for both streams.

Then join based on the record ID to get the output.

Many thanks

Shanker V