Crosstab is not doing it

[AmAm]

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

[ShankerV]

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

[ShankerV]

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.

[Felipe_Ribeir0]

Hi @AmAm 

One way of doing this