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!

[JosephSerpis · Accepted solution]

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.

[binuacs]

@JAB95 one way of doing this with 

Transpose the data and filter out based on the value 'Code' or 'Alias'

join with position

sort