Convert Multiple Columns into Two

JAB95

Hi Alteryx Community,

I'm trying to convert a file with multiple columns of hierarchy data (each pair of columns is a different level in the hierarchy, a code and an alias) into just two columns - one with all of the codes and the next with the matching aliases.

Please see the attached file I mocked up, with an example input and output.

Any help would be greatly appreciated!

Thanks!

AYX example.xlsx

JosephSerpis

Hi @JAB95 I came up with an approach that pivots the data and then extracts the relevant information from the headers to help sort the data when I then use a crosstab to pivot the information into the format you provided. It uses Regex to extract the information from the headers before the data goes into the crosstab tool.

Pivot_14042022.yxmd