I have almost 100 very old text reports that must be converted to excel. My
problem is the reports have been changed (no other way to export them) to run
two separate lines and I need them back to the single line. Ex:

Driver1 Time Hrs Balance Exception
Car Expended Hours Complete Work Defect
Eric 4 3.5 Yes No
15 4 .5 Yes

These lines need to be:
Driver1 Car Time Expended Hrs Hours Complete Balance
Exception Work Defect
Eric 15 4 4 3.5 .5
Yes Yes No

I'm a novice vba/macro person and welcome any suggestions.