Alteryx Excel Input - Horizontally Merged Cells

[ALT_2358]

Hi,

I have an awful Excel file which always gets downloaded in the same format every month. 

The main issue is that there are horizontally merged cells in the headers. 

I've attached a sample Excel file. Here's what it looks like after importing to Alteryx:

I wanted to ask if there's a way to clean this up within Alteryx to have columns as follows:

Country; Currency; Jan Spot; Jan Avg; Feb Spot; Feb Avg; Mar Spot; Mar Avg; etc.

Thanks in advance for any help!

[atcodedog05 · Accepted solution]

Hi @ALT_2358 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[ALT_2358]

Wow, thank you so much - it works perfectly!!

[atcodedog05]

Happy to help 🙂 @ALT_2358 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂