Fill blank columns headings using values in the column before

[sardamayank]

Hello Community,

I am struggling with fixing the attached dataset. I tried to use transpose and cross tab tools to fill the blank values, but it did not work out. Basically, I want to get month names in all the columns, so I can transpose the data to have one column for year, one column for months, one column for attribute (QTY or value) and one column for the actual value. 

File example attached.

Thank you for your help.

Regards

Mayank

[OllieClarke]

Hi @sardamayank I think this workflow does what you want:

I've attached the workflow below too. Hope that helps,

Ollie

[sardamayank]

Dear OllieClarke,

Thank you for the prompt response. Really appreciate it. 

Unfortunately, the file you uploaded has been created in a newer version of Alteryx than what I have on my system, so I cannot open it. Is there a way to share something compatible with version 2019.2.5.62427?

[OllieClarke · Accepted solution]

Hi @sardamayank here's a downgraded version.I've not packaged it, but the data input is the file you posted. Just make sure to tick 'first row contains data'

[sardamayank]

@ollieclarke - this works perfectly. I added transpose and text-to-columns tools to separate year, month and attribute, so all Good! Appreciate your help on this.

[OllieClarke]

@sardamayank Glad I could help!