Dynamically realign misaligned multi-row headers

Question

I am dealing with a misaligned table where column headers are spilt across multiple rows and shifted into the wrong positions. I need to dynamically move the header text to the correct columns and align them properly. (Each column will need to start with its correct title case header)

Header.xlsx

WirkKarl · Answer

You can dynamically fix misaligned headers in Alteryx by combining Multi-Row Formula + Dynamic Rename. Fill in missing headers, then promote the first row to column names. Works well for messy tables.

Raj · Answer

@bling_ 
Please provide more detail about how do you get input and if you have any source to reconcile the correct header or what the exact logic to decide the position

jrlindem · Answer

Are they always misaligned in the same way for all rows of data?  Curious how you would identify the misaligned rows from the correct rows (maybe it's just the ones with missing data in some of the columns)?

If the misalignment is consistent and you have a way to identify those rows, I would add a RecordID, then split the data with a Filter, use a Select to rename the fields to the correct position, and then Union the streams back together, using Sort to re-establish the order.

By if the data issue is varied and unpredictable, I'm not sure how you'd get the workflow to handle that dynamically unless there are patterns in the data that you can help identify to help with the shifting logic.

-Jay