Columns and rows switcheroo

[franc1s]

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!

[FrederikE]

Hey @franc1s,

I know that problem, it is quite confusing sometimes. 

 

 

[OllieClarke · Accepted solution]

Hey @franc1s 

You gotta transpose then Cross-tab swapping the rows and headers

AfterBefore

Hope that helps

Ollie

[OllieClarke]

@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

[franc1s]

Thanks everyone. I am also attaching some additional links that I came across after studying your answers.

Solved: Move rows to columns - Alteryx Community

Solved: Rows to column - Alteryx Community