Hi there

I need some help with a work report. I tried pivot tables but am surely
doing something wrong. I have the following data in a sheet:

Item Priority Status
a Critical Open
b Critical Open
c Critical Reopened
d Critical Closed
e Medium Open
f Medium Open
g Medium Reopened
h Medium Reopened

I would like to 'transform' the above to the following summary:

Critical
Open 2
Reopen 1
Closed 1

Medium
Open 2
Reopen 2
Closed 0

Any ideas?

Thanks in advance