Converting the Dates in the vertical row into horizontal row

Question

Hello community!

I want to basically changethe vertical axis to a horizontal axis and vice versa. Basically I want the dates (currently vertical axis) to become the new columns and move the previous column names to the rows. I know this question has been asked many times and everyone says use the Crosstab to do it, but i've tried and not sure if i'm doing it correctly. if someone could help that would be fantastic! I have attached a sample of the data I am working with at the moment. If someone could explain the steps for me or send me a workflow with how they did it I would be eternally greatful!

Alteryxexample.xlsx

Emmanuel_G · Answer

@Vkhaou

Find in attachement the way of doing this.

Let me know if there is any issue and do not hesitate to mark this answer as solution if it helped.

Transpose Date field.yxmd

davidskaife · Answer

Hi @Vkhaou

Your data is a little messy, but, the basics are as follows:

Using the Transpose tool to place the data in a vertical layout:

Then use the CrossTab tool to place the data in the required format:

You will end up with with the data in the right layout, but you will have to deal with the duplicated column names, and i've used the filter tool to just remove the first row of the original data for demo purposes

Hope this helps!

Crosstab.yxmd