To my opinion it will be very difficult or impossible a solution if the
without having the Data in front of us.
However, you may try to record a Macro of the Cutting/Pasting the data from
the 2nd. row, up to the 1st. row and Deleting the empty 2nd. row.
All this should be "nested" within some sort of loop.
Micky


"KKD" wrote:

The data I am bringing in to Excel comes in two rows for a single record. I
need to reformat it so that all of the data is on one line. As there are
several thousand records, I need to do find a way to automate this.

Any suggestions?
--
KKD