Monique wrote:
My goal is to create a Pivot Table by Buyer, PO#; summing on total invoice.
Ex.:
Buyer#1 120
PO#1 20
PO#2 100
Buyer#2 350
PO#3 50
PO#4 300

The raw data comes from a credit card download which has lots of empty
columns and rows. What's the best way to efficiently format the download
data in preparation to create a pivot table?
Download ex:
Account Number Date Invoice
# PO# Store Buyer Status SKU SkuDesc Quantity Unit Price Ex
Price Sub Tax Total Invoice
99006773958 8/1/2008 918742 2484 KRAMER DENNIS CL 14406 PFJ QTRD 106
11/16"X11/16 PC ($4.37) ($21.85)
EA ($1.97) ($1.97)

($21.85) ($1.97) ($23.82)

Hi Monique,

It's hard to tell from your example as usenet posts tend to wrap long
lines, but is are the records all in one row? If they are, you should be
able to use Data | Text to Columns to break up the data into
columns/fields. If you have blank columns, you will either remove them
or type dummy column labels in the first row. Then you're on your way to
a pivot.