Row of dates to become a column

[Harryjt]

Row 1 of a spreadsheet his a list of dates, I want this row to be column A and the data in column A to be row 1. effectively swapping the Y and X axis

[IraWatt · Accepted solution]

Hey @Harryjt,

What I think you want is the Transpose Tool. See my attached example:

This solution uses the transpose tool which can be hard to understand to new users. I would recommend checking out the community Getting-Started-Learning-Path for some context on how they work: https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117#done 

Any questions or issues please ask! 
Hope that Helps

Ira Watt
Technical Consultant
Watt@Bulien.com 

[Harryjt]

Great Thank You! I was unsure as to whether you needed to tick a column in key columns and as such it was messing it up. I'll watch the video you have linked and attempt now>