Transposing rows to columns every x number of rows

[Nevi1211]

Hi everybody !

I'm new to Alteryx and I'm struggling a bit transforming some data.

This is a sample of the data I have to work with. I have thousands of rows in the same format and I'm trying to put them in a more usual format.

from 

to this.

I tried the transpose module but it doesn't work in this case.

Any help would be appreciated.

thanks,

Nev

[Luke_C · Accepted solution]

Hi @Nevi1211 

Here's a way using the tile tool + cross tab. The tile tool will assign a value that we can use to group by and keep the data together. 

[messi007]

@Nevi1211,

Please see below :

Attached the workflow,

Hope this helps!

Regards

[Nevi1211]

Wow Thank you so much Luke ! that's works perfectly !

[Luke_C]

Happy to help @Nevi1211 , make sure you mark the solution to help people find the answer easier in the future. 

[Nevi1211]

thanks as well for your help @messi007

[messi007]

@Nevi1211,

If our solutions works please mark them as solved it will help others 🙂

Happy analysing and happy to help!

Best Regards,