Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Transpose columns under existing rows

DE22
6 - Meteoroid

Hello,

 

Could you, please help me with the topic below? I want to transpose "Day" column under the existing rows:

I uploaded the file.

Thank you 😊

 

Input:

DE22_1-1659617894890.png

 

Output:

DE22_2-1659617952103.png

 

 

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

Hi @DE22 

 

You are in luck. I just published 2 articles that might help you with this task. It's tedious but definitely possible.

 

https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-1/ba-p/9746...

https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-2/bc-p/9791...

 

Hope this helps : )

IraWatt
17 - Castor
17 - Castor

Was just about to link your article @atcodedog05 😄....

 

I made an initial start, I think it should be in a good format to start using the steps you outline in your blog.

IraWatt_0-1659619186045.png

 

 

atcodedog05
22 - Nova
22 - Nova

@IraWatt Aweomse 😎, Glad to hear 😀👍

IraWatt
17 - Castor
17 - Castor

Ah great timing on Part 2 of the blog ! @atcodedog05  🤣

DE22
6 - Meteoroid

Thanks a lot 😁

DE22
6 - Meteoroid

Thank you very much 😊

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @DE22 

Cheers and have a nice day!

Labels