We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks

Dynamically Bring date from Row to Column. Input data and expected output format displayed

irfanchoudhry
5 - Atom

Right now Date is displayed in Row , needs to convert into column dynamically. Sample input data and expected output file is attached. Input data is located in Input tab and expected result is located in Output tab of attached file.

1 REPLY 1
tim-regas
8 - Asteroid

@irfanchoudhry I've come up with this solution to achieve what you are looking to do. When pulling data in directly from Excel, merged cells can be a pain. I've handled them based on the source file you provided, but additional tweaking might be needed to handle all cases from the input file. Hopefully this gets you started though.Date Columns to Rows.png

Labels
Top Solution Authors