Rearrangement of Data

Question

Hi All,

So I have attached an excel sheet with 2 tabs - the input and the desired output using Alteryx!

I am new to Alteryx so I know the basics but wasn't sure how to fix the above - please note it can go on for over 100 countries

Kind Regards,

Viral Patel

Data transformation.xlsx

MarqueeCrew · Answer

@Vyx ,

As @JosephSerpis said, I'd use the TRANSPOSE tool too.  When you configure it, you'll want to:

* KEY COLUMNS {Name, Date}
* DATA COLUMNS {All of your country columns}

Then you would FILTER to keep where:

!IsEmpty([Value])

and finally, you'll use a SELECT tool to rename "Value" to "Country".

Cheers and Happy Alteryxing,

Mark

atcodedog05 · Answer

Hi @Vyx

1. Use transpose tool to convert columns to rows. Here is an interactive lesson which should teach you how to do it

https://community.alteryx.com/t5/Interactive-Lessons/Changing-Data-Layouts/ta-p/82876

2. Filter the nulls values from the country values column. Here is an interactive lesson which should teach you how to do it

https://community.alteryx.com/t5/Interactive-Lessons/Filtering-Data/ta-p/76301

3. Deslect column and rename as required as the last step

Let me know if you are facing any issues in understanding or tackling the use case I will be happy to help :)

Hope this helps : )

JosephSerpis · Answer

Hi @Vyx you just need to use a transpose tool for that challenge.

Transpose_06042022.yxmd