Hi Carol,
You can open the file in excel, then take a look at
http://www.mvps.org/dmcritchie/excel/snakecol.htm
to get the two rows into one row.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Carol Harb" <Carol
wrote in message ...
Has anyone been successful in doing the above?