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!
Solved! Go to Solution.
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
Hope this helps : )
@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
Happy to help : ) @catledbetter04
Cheers and have a nice day!