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
Solved! Go to 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.