Modified Pivot/Crosstab

[NeilFisk]

Hello Community,

I have a table that repeats columns that I would like to manipulate so that the similar columns are merged with new rows created.  I can visualize this in the attached Excel file where the original table is shown in "Initial Sheet" and the final results in "Intended Result".  I've tried a variety of ways but don't seem to get it.  Any help would be appreciated.

Thanks,
Neil

[Qiu · Accepted solution]

@NeilFisk 
Alteryx will not allow Column Duplication, so 1, 2,3 will be appended when imported.

[NeilFisk]

Qiu,

I was aware I couldn't have duplicate columns.  The initial table actually had that and when I selected dynamic rename for the first row (the columns), it appended the numbers which I was struggle with.  Your solution worked perfectly.  Thanks for the time and effort.

Regards,

Neil

[Qiu]

@NeilFisk 
Glad it helps.