I am looking for the easiest way to import the attached file into Excel so that analysis can be performed. The file was created by another application and has all the pertinent data. What I am struggling with is how to get the two lines of data onto one line in order to easily import it into Excel using the Text to Data feature. If you look at the copy/paste below, you’ll notice the header and the subsequent data is coming across on two lines. I cannot do a clean import into Excel and this is quite a big file. All suggestions are welcome.
CHECK
BANK CHECK # CHECK AMT CHECK DATE VENDOR # ADDRS # VENDOR NAME STATUS
WO # AMOUNT G/L ACCT # DESCRIPTION INVOICE # INV VEND
————————————————————————————————————————————
1 1 $38742.79 05/21/09 INT01 0 INTERNAL REVENUE SERVICE OUTSTANDING
38742.79 01-00000-20600-00000-000 PAYROLL TAXES FOR PE 4/24/09 PPE 4/24/09
1 2 $552.60 05/21/09 CON06 0 CONEXIS OUTSTANDING
552.60 90-00000-23327-00000-000 FLEX 125-DEPENDENT CARE REIMBS 051509
Thanks.