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

[JPSeagull]

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!

[Luke_C · Accepted solution]

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:

[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-Colu...