Using header from different rows in Excel to form new column in Alteryx

[CFuser87]

Trying to utilize Alteryx to reformat an Excel document for PowerBI and running into an issue where I need headers in excel to be in a different column.

Just wondering how I would do this in Alteryx.

My input/desired output is attached in the excel sheet.

[cjaneczko]

Here is one way to do it.

[usmanbashir · Accepted solution]

@CFuser87 - See attached workflow for the data transformations used to generated your desired output. Hope this helps!

[binuacs]

@CFuser87 One way of doing this

[CFuser87]

Thanks everyone for all your help! Greatly appreciate it!