May be this...

https://www.microsoft.com/office/com...7be&sloc=en-us

--------------------
(Ms-Exl-Learner)
--------------------


"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