Alteryx Puzzle

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.

Workflow

Accepted answers

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

Bacon

All comments

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

Bacon

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

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

Creating an annual calendar with multi-day events

That makes sense. Thanks for sharing!

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!

Quick Links

Tags

This months top contributors

erich_shiino 280