Need to convert Row Months into column Months

anthony99

Hi All,

New Alteryx user here and struggling mightily to get my data formatted in the way I would like.

I attached the alteryx workflow, can someone please help me convert the data into the excel layout?

Thank you so much in advance for your help.

Anthony

CMI Alteryx.yxmd

CMI Alteryx ideal layout.xlsx

Developer

Accepted answers

DataNath

Off my laptop and can’t think of an idea instantly off the top of my head but if you just need that report for now then could chuck a select tool on and rearrange columns. Can take a look at a more dynamic solution later if nobody else has!

All comments

DataNath

Hey @anthony99, you haven't attached your input or provided a packaged workflow with the asset included, so we can't get the input data when opening your provided workflow. Are you able to provide this so we can have a crack? If it's confidential/sensitive data then feel free to use dummy values. Cheers!

anthony99

Hi DataNath, thank you so much for your help. I attached the input file

CMI Analysis 5,12.xlsx

DataNath

How does this look @anthony99? The headers aren't stacked but other than that seems to look like what you're after.

Transformed CMI Data.yxmd

anthony99

Thank you so much! Would there be a way to sort the months? My fiscal year starts in Month 9?

grazitti_sapna

Hi @anthony99 , Try this workflow I did some mapping to get to the desired result. I hope this helps!

Also, do not forget to mark my post as solution if it helps!

Thanks!

anthony99_CMI Alteryx_Updated.yxmd

grazitti_sapna

@anthony99 did you get a chance to try my workflow out? Just wanted to know if it is helpful!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703