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