Transposing data

[alejandro_jimenez]

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.

[ncrlelia]

Hi @alejandro_jimenez,

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