We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Rows to columns- HELP!

Lizbhernan
8 - Asteroid

Hello Alteryx Community!

I’m working on a workflow where I need to transform certain rows of data into columns. Since I haven’t used the Cross Tab tool very often, I’m unsure of the best approach to achieve the results I’m looking for.

I’ve attached a sample dataset along with the desired output for reference. Any suggestions or guidance would be greatly appreciated!

Thanks in advance!

2 REPLIES 2
jrlindem
11 - Bolide

Add a Record ID Tool and then reconfigure your CrossTab Tool to look like this:

jrlindem_0-1757019307680.png

 

Use a formula tool to rename the Record ID's into "Week" ahead of the Crosstab tool if needed.  The attached workflow handles the formula for the weeks headers.

Lizbhernan
8 - Asteroid

@jrlindem Thank you so much for your help 😊

Labels
Top Solution Authors