Bring Columns to Rows

Question

Hi Everyone,

I am requesting some help with alteryx.

I have data in the format of sheet1, and want to achieve the format in sheet2.

You can see that in the current format I have data columns with month number/indicator, and I want it to get aligned with the appropriate rows.

Thanks in advance for your help.

Sheet-1

Sheet-2

DummyDataInput.xlsx

RolandSchubert · Accepted Answer

Hi @MahmudSaniat ,

I think, using the Transpose tool and some calculations you should get the result. I've attached a sample workflow.

Let me know if it works for you.

Best,

Roland