Modified Pivot/Crosstab

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

Example.xlsx

Preparation

Accepted answers

Qiu

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

0809-NeilFisk-1.yxzp

All comments

Qiu

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

0809-NeilFisk-1.yxzp

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.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335