Hi,
I have some data which looks like this:
Co1 RType1 B2
Co1 RType2 B2
Co1 RType3 B
Co1 RType4 B
Co2 RType2 B1
Co2 RType3 B
Co3 RType1 B2
Co3 RType3 B+
Co3 RType4 BB-
Co4 RType1 Ba3
Co4 RType2 Ba3
Co4 RType3 BB-
Co4 RType4 BB-

I would like it to look like this:


Name RType1 RType2 RType3 RType4
Co1 B2 B2 B B
Co2 B1 B
Co3 B+ B+ BB-
Co4 Ba3 Ba3 BB- BB-

I hope I've made that clear. It's a kind of 3 dimensional look at the
data. Is Pivot tables the way to go here? When I try to get the data
in a Pivot table, it tries to give me a "Sum of" or a "Count Of" the
data, rather than the data itself. This is not what I need. Is there
another way I'm missing? Thanks,
Michael