put a row below every each column

[Danilo9017]

Hi All 

I am struggling on Alteryx about my data set. 

I start from this situation with all data organized on the rows 1 and 2 

I would need an output like this (so basically every seven columns the other seven columns should be put above as a raw) 

do you have a specific solution/workflow for that? i try transpose  tool  but no results on this topic. I attached my input and the output i should have from alteryx 

Danilo 

[JarekSkudrzyk]

@Danilo9017 hi, tough one for me as well, but I managed to get to the desired solution:)

Please take a look at what I have came up with - it involves iterative macro and a number of other tools.

[binuacs]

@Danilo9017 another way of doing this

1. you need to transpose the data 

2. group the data into 7 records with the tiles tool

3. cross tab the records 

4. again group the data into 3 records for sorting purpose

5. sort the records based on the new tiles number

6. output to xlsx by checking the property Skip field names

[JarekSkudrzyk]

@binuacs great solution - simple and effective! I did not realize the full potential of the tile tool:)