Reporting conundrum with fixed data

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

One possibility- set the table up on another sheet (lets say sheet2) with the
row and column headings (if you have a lot of row/column headings, you could
probably use advanced filter to get the unique items, then copy/paste or
copy/pastespecial-transpose to get the headings for the second table set up.

Then in Sheet2, cell B2 (assuming your original data is in Sheet1!A1:C13)

=INDEX(Sheet1!$C$1:$C$13,MATCH($A2&B$1,Sheet1!$A$1:$A$13&Sheet1!$B$1:$B$13,0))

Then copy across and down. Modify ranges as necessary. If you like, copy
then pastespecial/values to hardcode the data and delete Sheet1 (just be sure
to backup).





"michael.blaustein@gmail.com" wrote:

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