Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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