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/...soft_excel.htm
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"Dan" <[email protected]> wrote in message
news:[email protected]...
>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!
>