D
Dharmy
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
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