Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to pivot and make multiple columns to one column

LasseWaern
5 - Atom

Hi,

I want the data to be structured so I have all the prices listed in 1 column and not in several. This is because I have data from 2009Q1 to 2019Q4 but all the quarters are in its own Excel-file.

Therefore, I want the data set to be changed like this:

 

image.png

 

If it doesn't make sense I've also attached an Excel-file of how it looks (2009K1) and how it's supposed to look (2009Q1).

 

I hope some of you can help me make my data sets look like how I want them to be.

 

Thank you very much.

 

BR

Lasse Waern

2 REPLIES 2
afv2688
16 - Nebula
16 - Nebula

Hello @LasseWaern,

 

Is this ok for you:

 

Untitled.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

LasseWaern
5 - Atom

Thank you very much for your response.

It seems to work so thank you very much! 🙂

Labels