Record information is on two lines

[Dan]

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!

 

[Anne Troy]

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