Ok, here is my question or predicament. I have an extract from a Database that is format such:

Name Date Type Result Limit
a1 1/1/1999 Type1 11 0.5
a1 1/1/1999 Type2 0 0.5
a1 1/1/1999 Type3 123 0.5
b1 1/1/1999 Type1 10 0.5
b1 1/1/1999 Type2 14 0.5
b1 1/1/1999 Type3 0 0.5
c1 1/1/1999 Type1 25 0.5
c1 1/1/1999 Type2 100 0.5
c1 1/1/1999 Type3 0 0.5

What I want to do is reformat this data to this kind of setup:

Type1 Type2 Type3
Name Date Result Limit Result Limit Result Limit
a1 1/1/1999 11 0.5 0 0.5 123 0.5
b1 1/1/1999 10 0.5 14 0.5 0 0.5
c1 1/1/1999 25 0.5 100 0.5 0 0.5

I have tried using a Pivot table but the always uses some kind of calculation for the field that is in the "values" area (i.e. Max, SUM, PROD, etc..). What I am trying to do would work with a pivot table of I could just use actual values instead of some sort of calculation.

I may not have explained it thoroughly but I think you get the premise.

Unfortunately this post doesn't like the spaces that I put to make those tables in to nice and neat columns. I can write up a quick example excel file in a few minutes if you need it.

Thanks in advance for any help you can give me!