Merge Header with Second row to create custom header

[PKoya]

Hi,

I have a dataset which has month and year in two separate rows. Below is how it comes to us.

Any way to combine the header with the month row and arrive at Header in MMM-YY text format?

This would really be helpful for me. I have tried different approaches but they don't seem to be working for me.

[Emil_Kos]

Hi @PKoya,

There is a problem with the headers that have only 2021 in the header. As you are not allowed to have the same headers in Alteryx.

Maybe alternatively you just can add the year number by hand?

[KarolinaRoza]

Hi @PKoya,

I propose my solution. I think it should work despite the year which you are having in first row.

Let me know if it works for you.

Karolina

[RaviP]

I took a similar approach to @KarolinaRoza 's. 

I checked the 'First Row Contains Data' and used my workflow. Hope this helps as well.

Ravi