Transposing rows to columns every x number of rows

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

Accepted answers

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.

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.

Please see below :

Attached the workflow,

Hope this helps!

Regards

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

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

messi007

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

Happy analysing and happy to help!

Best Regards,