I threw together a macro using ASCII File Process. Hope this helps. BTW, i'm using ME3 not MEP but there shouldn't be any differences here.
This file process seems to ignore blanks. Hope this helps! How this works is that each loop it moves down a line.
So data from A4 = %t1%, B4 = %t2%, ect.
When it loops A5 = %t1%, B5 = %t2%, ect.
That is why you would only need %T1%
// Save a text file called asc processing file.txt
// Have a spread sheet called Microsoft Excel - Book 1 Temp open
Activate Window: "Microsoft Excel - Book 1 Temp"
Text Type: <F5>
Delay 0.5 Seconds
Text Type: Sheet1!A4:A204
Text Type: <ENTER>
Delay 0.5 Seconds
Clipboard Copy
// // Settings: "Save Clipboard to a Text File"
// // Settings: You will need to browse to the .txt file and choose it
Clipboard Save Text: "asc processing file.txt"
Delay 0.5 Seconds
Text Type: <F5>
Delay 0.5 Seconds
// Below puts it back into excel but you would need activate what ever program when you run the real deal.
//Putting it back to excel was just for testing
Text Type: Sheet1!B3
Text Type: <ENTER>
Delay 0.5 Seconds
ASCII File Begin Process: "asc processing file.txt" (Tab Delimited Text )
Text Type: %T1%
Text Type: <ARROW DOWN>
ASCII File End Process