Record information is on two lines
 

I have an EXCEL SS with information as follows;
Record 1: A1, B1, C1, D1, A2, B2, C2

Record 2: A3, B3, C3, D3, A4, B4, C4

I would like to fix so each record is on one line:

Record 1: A1, B1, C1, D1, E1, F1, G1

etc.....

Thanks for any help!

Record information is on two lines
 

Use a method such as one at the link (see "vertical to horizontal...")
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"Dan" wrote in message
oups.com...
I have an EXCEL SS with information as follows;
Record 1: A1, B1, C1, D1, A2, B2, C2

Record 2: A3, B3, C3, D3, A4, B4, C4

I would like to fix so each record is on one line:

Record 1: A1, B1, C1, D1, E1, F1, G1

etc.....

Thanks for any help!