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

[cjaneczko]

Can you include your sample data?

[john_q6]

the file is attached

[john_q6]

It's attached now.  Apologies.  I didn't know the flow needed the file as well.

[cjaneczko · Accepted solution]

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

[john_q6]

Thank you.  Let me dig into this so I understand the process.   I'll mark the the solution once I get the time to digest this.

[john_q6]

Apologies for the delay.  Thank you for the solution.  I was able to reverse engineer it and understand the concepts.

[cjaneczko]

Glad it worked out.