Hi,
I am new at alteryx, I want to transpose some data. I attached and example excel file. I want to eliminate (or ignore) all the lines above line 5 and below line 13, as well as line 6 and 10. After that, I want to transpose the data to make the rows into columns (column R1.1, R1.2, R1.3, R2.1, R2.2, R2.3) and the columns into rows (rows C1, C2, C3, C4).
I have tried the transpose tool but I get all the columns stack one over each other.
Thanks for the help.
You would have to first transpose Cs into rows then cross tab the Rs into columns.
Please see attached my suggested solution.
Hope it helps.
Cheers,
Lelia