Row Fields to Columns

[catledbetter04]

Hello - 

I have a large data set that has transaction types listed in rows. I'm trying to get the transaction type by column in order to see charges, discounts, etc. by individual invoices. See example data and desired output below. Any help is much appreciated! 

[atcodedog05 · Accepted solution]

Hi @catledbetter04 

You can achieve this using cross tab tool. Here is an interactive lesson on it refer to crosstab tool section.

https://community.alteryx.com/t5/Interactive-Lessons/Changing-Data-Layouts/ta-p/82876

https://help.alteryx.com/20214/designer/cross-tab-tool#:~:text=Use%20Cross%20Tab%20to%20pivot,data%2....

Hope this helps : )

[Qiu · Accepted solution]

@catledbetter04 
Here are a few solved threads about the Transpose and CrossTab.
Hope you will find it useful.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Transpose-crosstab/td-p/736021

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Crosstab/td-p/590504

[Kamran1991 · Accepted solution]

Hi @catledbetter04 

Hope this will resolve your query.

Thanks,

Kamran

[atcodedog05]

Happy to help : ) @catledbetter04 

Cheers and have a nice day!