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)
99006773958 8/1/2008 936183 DIANNE 186 SPENCER ERIC CL 21687 36" RB 9-LITE 2
PANEL RH 1 EA $137.18 $137.18
3969 WOOD SHIMS NELSON 14PC.PA 1 EA $1.09 $1.09
44906 JH 10 OZ LN HEAVY DUTY 1 EA $2.27 $2.27
126142 BOS 16G 2" FINISH NAIL 1 EA $8.92 $8.92
1 EA $7.47 $7.47

$149.46 $7.47 $156.93
99006773958 8/1/2008 901329 SCOTT 2484 BENDER AARON CL 128508 R13 3
1/2X15X32' PERF COM 1 BA $12.67 $12.67
1 EA $0.63 $0.63

$12.67 $0.63 $13.30

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.