Forum Discussion

marami21's avatar
marami21
Frequent Visitor
7 years ago
Solved

Stack columns one after the other

I have something like this: And I need to change it to something like this.               I know this can be done with unpivoting but I've tried several times and I have not been a...
Need Help
Tutorial Requests
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi marami21 

     

    Please see the attached solution, its three steps using UI only.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
7 years ago

Hello marami21 

I think what you need to do is split your original table into blocks then stack them.  In the attached file there are 5 queries.

The first one just pulls in the data

The next three reference the first one (no reason to load the data again) an pull just the set of columns for that block then renames the columns

The final query stacks together the previous three

All but the final query are set to not load to the model since we only care about the final result.

 

My sample file is attached for you to look at.