flipping Excel data sideways

[remarque]

Hey folks,

My company's invoicing program outputs data to an Excel spreadsheet
with the following header row:

Line Item Type, Customer Name, Invoice #, Invoice Date, Amount

and then lists each row as a Line Item. Thus, each invoice will show
up in as many rows as the number of its line items and there's thus a
lot of duplicate data.

Our accountant would like us to provide her with the spreadsheet where
each invoice only shows up once, by row, with columns to break down the
Line Item Types. The header row for this spreadsheet would look like
this:

Invoice #, Invoice Date, Client Name, Line Item Type 1, Line Item Type
2, Line Item Type 3, ...

with the sum of each line item type, per invoice, in the corresponding
cell in each row.

Can you provide me with suggestions on how I can set up Excel to flip
the outputted spreadsheet into the desired one for the accountant?

Thanks!!

 

[jpdphd]

I think you can do what you want with a pivot table.
Take a look at this.
http://homepage.mac.com/jdilger/Excel/PivotTable.jpg
Is this what you want?
Do you know how to do pivot tables?
If not, I can e-mail you an example.