Formating imported data

W

w.gates

This is what I get:
A B C
Date Line1 Text
Line2
LineX
Date Line1 Text
Line2
Date Line1 Text

This is what I want:
A B C
Date Line1Line2LineX Text
Date Line1Line2 Text
Date Line1 Text

I've found a macro to join the rows, but I've been selecting them
manually. It's a real pain when the number of records is high. I'd like
to loop through the files to select the appropriate number of rows, call
the macro to join the rows, and then move on to the next.

Any suggestions?
 
Top