How to Use Transpose

[jenner85]

M$		2011-11-01	2011-12-01	2012-01-01	2012-02-01
Interest		5000	450	375	500
Fees		500	390	500	20
Rebates		630	785	999	1000

Hi - How do I flip these so that they are listing the categories across the top and the dates along the side, with the dollar amounts for each as the data?

Can't seem to figure out the transpose tool.

thanks!

[jarrod · Accepted solution]

you should be able to use the Transpose tool first (Key fields = M$) (Data Fields = All other fields)

Add formula after transpose and modify the Value field with the following formula:

'$'+[Value]

Then follow that with the cross tab tool where:

group data by: Name

New Column Headers: M$

Values for new columns: Value

you can also format the numbers in a table tool if you are going to render it later anyway.