Reports. Group by/ count. Show "out of stock if count(item)=0, "In stock" if count(item) > 0

Reports. Group by/ count. Show "out of stock if count(item)=0, "In stock" if count(item) > 0

Basically have a report showing something similart to this:

ID Type
6524 A
8472 A
2145 B
3254 B
1254 B
2158 B
6528 B
1235 D

Want to alter it so a get a report likt this:
Type Count
A In Stock
B In Stock
C Unavailable
D In Stock

Is this possible, anyone done something similar?

If I use pivot table, I can get the following:
Type Count
A 2
B 5
D 1
 But I do not want to show the actual count. Want just to show "In stock" (or "more than 2")

Thanks.