Pivot table

[sohaibj]

I've data with following headings:
Item Code
Description
Quantity

I have placed Item Code and Description in Row Labels and Quantity in Values box. It's showing like this:
Item Code
Description
Item Code
Description

But I want result like this

Item Code Description in the same row

 

[danzon]

Right click in the pivot table

click the Display tab

tick the "classic pivot table layout" box

click ok