pivot table help

[ultratch47]

i have been tring to do this for a LONGG time... i give up and beg for assistance!!

when i make the pivot table the 2nd column has 3 rows for one slection on the first column...
what i want is for it to list these three seperate rows all on the same row, so it take sup less space, and so i can sort the data by a column.

it looks like this (off topic "?", how do i show an excel doc on this forumn)
i have about 6000 rows of data, this data has 5 columns i want to view
if the item appears more than once, it is listed on more than one row, so first thing, i want to see how many of each item on the report (count of item)
now i just want to list the price and the description to the right of this on the same row...

any suggestions?
i currently put:
item on data ( to get the count
item on row (to get the item #)
price on data ( to list the max price)
description on data ( to list the desc of item)

but this gives me 3 rows for each item (count of item, desc, and price)

thank you VERRRY much in advance... if i can tackle a pivot table after this, my life is a lot less stressful..
ps. yes i have tried reading help and what not, but too no avail

 

[pcc]

left click and hold the cell that has the text "Data" in it.
Then drag the cell to the right - over the next cell to the right, and let go.