Rows to Columns in Alteryx?

Question

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 Answer

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".