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

Reporting conundrum with fixed data
 

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





" 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