I am trying to Transpose Row 1 to become Column F1 and so on. I was wondering if there was a simpler way of doing this process instead of using multiple Transposes
I've done something here with some random data. You need to change the input and configure accordingly:
In the future, it is easier for us in the Maveryx community to help you if you can provide raw data in a flat file rather an image.
Hope this helps.
-Cal
Hi @mquast
Could you share some sample data and a sample of your expected output?
The first table is what the results should look like and the second is the input
@caltang Maybe I am missing some point here, but I use only transpose and Cross Tab tools.Thank you for your dummy data😀
Haha! @Qiu my brain sometimes cooks up solutions that are more complex than they should be!
Yeah, @mquast - @Qiu’s solution is much more straightforward. Hope it helps!
Oh! Now I remembered why I did it that way. I am trying to accommodate all data types in the input files. I’ve changed the data into strings so that it is dynamic. I guess I went overboard this time too!
@caltang Trust me, we all had that moment..😂
My solution
@mquast another way of doing this
Thanks for the solutions. None of this takes away from the fact that Alteryx ought to provide a single, simple tool that does the job.
