Transpose columns under existing rows

[DE22]

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:

Output:

[atcodedog05 · Accepted solution]

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 · Accepted solution]

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.

[atcodedog05]

@IraWatt Aweomse 😎, Glad to hear 😀👍

[IraWatt]

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

[DE22]

Thanks a lot 😁

[DE22]

Thank you very much 😊

[atcodedog05]

Happy to help : ) @DE22 

Cheers and have a nice day!