Complete Table Transpose

[mquast]

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

[Luke_C]

Hi @mquast 

Could you share some sample data and a sample of your expected output?

[mquast]

[mquast]

The first table is what the results should look like and the second is the input

[caltang · Accepted solution]

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

[Qiu]

@caltang 
Maybe I am missing some point here, but I use only transpose and Cross Tab tools.
Thank you for your dummy data😀

[caltang]

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!

[caltang]

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!

[Qiu]

@caltang 
Trust me, we all had that moment..😂

[sparksun]

My solution