Transpose Help - Have up to 5 groups of 5 values each group I need to move to columns

I cannot figure out why my transposing effort isn't getting what I need. I have repeating data that I have to move from rows to Columns, but I can't find the right combination of the transpose and cross tab tools.

I am trying to get the final results to look like this, but up to 5 groups of payment priorities.

I have gotten this far:

Any advice would be appreciated. Thanks!

Transpose Help.yxmd

Developer

Accepted answers

Luke_C

Hi @JPSeagull

You're so close! You need to make unique headers, the way you have it now just has 1-5 as the headers. I created your desired header with a formula tool and used that in the crosstab:

Transpose Help.yxmd

All comments

Luke_C

Hi @JPSeagull

You're so close! You need to make unique headers, the way you have it now just has 1-5 as the headers. I created your desired header with a formula tool and used that in the crosstab:

Transpose Help.yxmd

JPSeagull

@Luke_C - Thank you! I knew I was missing something and when I got up this morning thinking about it, I realized that I needed to add the additional labels for new headers. Thank you so much for your help!

JPSeagull

@Luke_C - I was asked now to add to this workflow identifying certain payment methods as being eligible or not for payment assistance. I posted a new question because the issue is now the number of payment methods fluctuates and I need to set a filter in Alteryx to take into account the event there are more payments methods a customer has than previously report. https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Is-it-possible-to-Wildcard-Search-Column-Names-for-use-in-a/td-p/1088900

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703