How to flip the direction of data in Alteryx?
Category:
Question ID: 109951
0
0

I have a pretty simple problem and I can’t find a simple solution. I basically just want to turn all my columns to rows and vice versa, and not keep headers. I thought this would be pretty simple but no combination of transpose/cross tab seems to get it looking how I want. What am I missing?

Marked as spam
Posted by (Questions: 9, Answers: 0)
Asked on November 3, 2020 10:11 am
47 views
Answers (1)
0
Private answer

Here's a simple workflow that does what you need. I did a transpose with everything as a data column, and then tiled it on names, set to equal numbers with the same number of tiles as you want rows at the end. Then cross-tab and clean up and you're done. The attached screenshot shows the cross-tab settings.

Attachments:
Marked as spam
Posted by Weston (Questions: 0, Answers: 0)
Answered on November 3, 2020 10:37 am
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top