Record information is on two lines

D

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!
 
Top