how to get column name of left column and update right column with result

[Dapo]

Please I need help with this

Currently my sheet looks like this

June 2021	Field 17	Field 18	July 2021	Field 20	Field 21
YTD	MTD	MTD	YTD	MTD	MTD
752	362	677	533	643	115
344	126	775	353	246	678
245	643	772	878	535	744

Here's the result I'm hoping for - updating specific column name in respect to the left column

June 2021	June 2021	June 2021	July 2021	July 2021	July 2021
YTD	MTD	MTD	YTD	MTD	MTD
752	362	677	533	643	115
344	126	775	353	246	678
245	643	772	878	535	744

Many thanks

[drew9 · Accepted solution]

Hi @Dapo , 

Unfortunately Alteryx does not support having 2 or more column headers with the exact same name, so we have to get a little crafty. I have attached an example solution here. Hope this sparks some inspiration.

[Maskell_Rascal · Accepted solution]

Hi @Dapo 

Alteryx won't allow you to name fields the same. When you try to do this, it will rename each duplicate field with an underscore and number to show the duplicate field names. So the best you could do is rename all your fields like this:

Let me know if this answers your question. 

Cheers!

Phil

[atcodedog05 · Accepted solution]

Hi @Dapo 

Here is how you can do it. I have added to space to name to make them look alike.

Workflow:

Hope this helps : )

[Christina_H]

As another option, you could shift the month names down into the first row of data and keep generic headers.  You could then e.g. put the data into a table without column headers before rendering out.

[Dapo]

Thank you @drew9

[Dapo]

Yes it answers my question perfectly, thanks @Maskell_Rascal

[Dapo]

Yes it does help - thanks 🙂

[atcodedog05]

Happy to help : ) @Dapo 

Cheers and have a nice day!