Rows to Columns in Alteryx?

[Jo_the_stats]

So here's what I've got currently- we've got multiple dates by row. This isn't terrible if I'm, say, taking the entire network's totals at once and comparing year-on-year, but if I want to spread out each site as its own column, how would I do that?

Here's what I've got currently

And here's what I'm trying to get it to do, which I did manually in excel (obv. I don't want to have to do this for years.) Is it Transpose? Cross-tab?

Here's what I'm trying to get

[caltang · Accepted solution]

You can do so using the Cross-Tab tool. Like so:

In your case, I would group by Date. Then change column name to Site ID, and value to be SUM_INTERVAL_VALUE, and choose "Sum".

[caltang]

If you are stuck and unsure, kindly provide some raw data for us and we will cross-tab with you so that you can better understand if needs be.