Rows to Columns

[ftorruella1]

Hi!

I need to transform rows to columns (as opposed to columns to rows which you can use transpose). I have a column with each month and another column with the revenue for that month. I need to make the months the column headings and revenue as the data under each.

Input:

Entity     Month      Revenue

Store     Jan-19           99

Store     Feb-19          100

Store     Mar-19          109

Output:

Entity     Jan-19   Feb-19   Mar-19

Store          99         100        109

[jrgo]

Hi @ftorruella1 

The Crosstab tools is what you're looking for. Here's an example...

[JosephSerpis · Accepted solution]

Hi @ftorruella1 I mocked a workflow that will crosstab your data and give the output your describe without having to manually re-order the months.