Rows to columns- HELP!

[Lizbhernan]

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!

[jrlindem · Accepted solution]

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

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]

@jrlindem Thank you so much for your help 😊