Hi,
We have an invoice in text format in excel. I need to convert in a
table format to be able to convert it into a pivot

I need macros created which can
1) delete blank rows
2) delete rows which start with certain text in a particular (the
invoice heading appears frequently in every page)
3) each transaction is in 2 lines- need it to be in one line

PAGE
ROSANA ALAM 36422299601017
FINANCE CONTROLLER 30/03/10
MICROSOFT GULF FZE LLC
MICROSOFT STAFF 1
P O BOX 52244
DUBAI
AGN CODE:01 AGN NAME :DNATA TEMPORARY STATEMENT FOR MARCH
2010
DATE TICKET TRANS PASSENGER NAME DESCRIPTION VALUE TAX DISCOUNT
AMOUNT
REF. NO. TYPE ROUTING PAYABLE

OPENING BALANCE 2 ,840,384.13
PAYMENT RECEI VED
28/03/10 Payment Received 0.00 0.00 0.00 1 ,465,957.00CR
EB290316
TOTAL 1 ,465,957.00CR


DEPARTME NT 1
23/02/10 681 0000330760 SVC MR XXXXXXX InvNo:XXXXXXXXXXXX 140.00 0.00
0.00 140.00
1333843 140.00

23/02/10 176 3842850331 ATB MR. ABDCDEEEE InvNo:XXXXXXXXXXX 2,830.00
280.00 0.00 3,110.00
33495 ACC/DXB 3,110.00