put a row below every each column

Question

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

test danilo alteryx input.xlsx

test danilo alteryx output.xlsx

JarekSkudrzyk · Answer

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

binu_acs · Answer

@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

multi-row.yxmd

JarekSkudrzyk · Answer

@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.

New Workflow2.yxzp