Need help creating a pivot table with Summarize tool

[CDIns]

Business	Currency	Region	Type	Amount
A	USD	Mid Atlantic	Revenue	8
B	USD	Mid Atlantic	Expense	3
C	CAD	Toronto	Revenue	7
D	CAD	Toronto	Expense	5

I am trying to split out the amount column into (2) columns - One for Revenue and One for Expense. 

Can somebody please assist? 

I appreciate the help, 

[alexnajm]

Have you tried the Crosstab?

[CDIns]

@alexnajm  I am not familiar with this tool. How would I configure to break out the amount column into 2 columns by type? 

[alexnajm]

@CDIns screenshot has been posted - you can play around with the groupings if you need it to aggregate differently!

[CDIns]

@alexnajm  sorry, your screenshot did not load initially. Let me take a look and see if this works - thank you for the suggestion.

[alexnajm]

No worries @CDIns ~