Rotate_Pivot_Transpose question

john_q6

Good morning.  I'm brand new to Alteryx and learning via a udemy class and on the fly.

I have some data from a pdf - brought into excel - then into alteryx.

In my situation, i want to rotate the data from the attached workflow to a format that matches a copy-transpose in excel (attached image).

With my efforts, i can't seem to get the rows/groups from "Column1" to breakout and be the new columns with their respective data.

Any help is appreciated.

Thank you

Pivot_Transpose.png

3Round_Sample.yxmd

cjaneczko

Try this. The first Transpose is only grouped on Column 1 with the Data Columns being every other column. The formula for the Multi Row Tool is below. The Crosstab is grouped by Name and Record ID, with the Headers being Column 1 and the values being Value. You can pick any of the Aggregations, I did Concatenate. The Join is on name on both the Left and Right. 

if isnull([Row-1:Record ID]) then 1 elseif [Row-1:Name] != [Name] then [Row-1:Record ID]+1 else [Row-1:Record ID] endif

3Round_Sample.yxmd