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
Solved! Go to 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
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>