I believe this is a simple problem. I havent been able to solve it so far.
My gut feeling says "solve it with the transform tools". Just my luck that I am pretty bad using most of the tools in that section. If you have some material that you can point a beginner+ to, id appreciate it.
The problem.
My data: capture 5 attached
My desired data: capture 6 attached
I'm sure that there are multiple ways of solving this, so, bring it on ;-)
Thanks!
Solved! Go to Solution.
@franc1s
I'd recommend the interactive lesson on transforming data
https://community.alteryx.com/t5/Interactive-Lessons/Changing-Data-Layouts/ta-p/82876
Also look at weekly challenges to practise as well!
Ollie
Thanks everyone. I am also attaching some additional links that I came across after studying your answers.