Fill blank columns headings using values in the column before

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

Book1.xlsx

Transformation

Accepted answers

OllieClarke

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'

blanks.yxmd

All comments

OllieClarke

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

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

Ollie

blanks.yxzp

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?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703