I am trying to change the layout of a pivot table so the 2 columns with 3 values are not duplicated with each other. Essentially I want only the 6 columns (2x3) of data to show, rather than the 18 (2x3x3) combinations which are being presented.

Due to my lack of terminology, I was unable to find the solution to this simple problem, though I am sure I have resolved it previously. Thanks for your help - see sample images attached (having trouble loading an attachment).

First image has data on the left, current pivot table at top right and required pivot table at bottom right.
Second image has the current pivot table selections

1-02-2013 12-26-09 PM.png

1-02-2013 12-27-31 PM.png