Consolidate data in a table

J

Jack Burman

Using Excel 97. I have a table made from a csv file from eBay which lists my
auction items and various fees. Each fee type is in a different row and I'd
like to place them all on one row with the appropriate item no. and
description (so I can total all fees for a specific item). I like to do this
without cutting and pasting.
Looks like this:
1234567890 Whatchamacallit Insertion Fee $0.35
1234567890 Whatchamacallit Picture Fee $0.15
1234567890 Whatchamacallit Final Value Fee $0.67
Would like this:
1234567890 Whatchamacallit $0.35 $0.15 $0.67 $1.17
with appropriate column headings, of course.
Can I do this, and how?
Thanks
 
F

FMolina

Hi:

There are several ways to do it, however the most efective one I can think
of is to use a pivot table. They're very simple to create, just follow the
Pivot table wizard in the Data menu dropdown. Select the excel list and pivot
table options. Than select the range where you have your data. After that go
to layout, put your item # and description fields in the "row" area side the
fees concept field in the "column" area and the amount field in the "data"
area.

Hope this helps,

Francisco Molina
 
J

Jack Burman

While I fight with the pivot table, can you give me another idea of what
might work? I'm having problems with the pivot table giving me a sum of fee
type (ie: 1 of a certain fee type) rather than the amount of the fee type
(ie: 0.35). I was able to add a second field that showed the amount, but I
can't get rid of the first (sum of fee type) field that the pivot table
generated.
Thanks.
Jack Burman
 
Top