Importing or Changing the data from a FORMATTED Excel Worksheet into Tabular Form

Hi,
I have large sets of data from an external system that is preformatted for printing. Unfortunately this means all relevant data is not in a tabular format that I can sort and run additional analysis on. I have attached a file with sample data, but I am looking for a way to pull data from a worksheet formatted like:

Name 1, Dept
XX-XXXX1
Address 1
City, State Zip Code USE

Posting Date Transaction Date Description Receipt Amount Posted Amount Expense Amount
07/9/2014 07/09/2014 Vendor 1 2,039.94 2,039.94 2,039.94

Expense Description: Pink Bunnies

Accounting Codes
Inventory Transaction?: No Part Number: N/A Work Order #: n/a
Operating Unit: 02 Department: 66666 GL Account: 12345678
Fund Code: OPR Function: 041 Project: Project Not Required
Activity: Activity Not Required

In to a format like:

Name Card# Address 1 Address 2 Posting Date Transaction Date Description Receipt Amount Posted Amount Expense Amount Expense Description
Vendor 1 X-XXX1 Address 1 City, State, Zip Code 07/09/2014 07/09/2014 Vendor 1 2,039.94 2,039.94 2,039.94 Pink Bunnies

Thanks in advance for any assistance,
Zinnia