Alteryx Puzzle

[maludw0]

Good morning Alteryx Community:

I have a quick question for all the gurus out there.

I have a dataset 

Start With this

I am trying to organize it like this:

End with this

Please let me know if this is possible.  I would really appreciate the assist. Thank you.

[abacon · Accepted solution]

@maludw0 yes this is possible, requires a little moving around but here you go!

Bacon

[maludw0]

Thank you so much.  I had most of it, but your quick response was greatly appreciated.

[dreldrel]

Just out of curiosity - what is the use case for this specific layout?

[maludw0]

Creating an annual calendar with multi-day events

[dreldrel]

That makes sense. Thanks for sharing!

[MinhLO]

Interesting one. Wanted to give it a go, and ended up with a quite similar solution than @abacon .
The difference is we did not migrate yet to 2025.2, so could not use the data cleanse pro!

Instead created a manual mapping 

Hope it helps if you are not using 2025.2!