pivot table help

ultratch47

Board Regular
Joined
Aug 6, 2002
Messages
126
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
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

pcc

Well-known Member
Joined
Jan 21, 2003
Messages
1,345
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,207
Messages
5,594,839
Members
413,943
Latest member
Dhornsby21

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top