Fields in a record are on the next line

D

Dan

I have a SS with six fields as follows:
Record 1-
A1, B1, C1, D1, A2, B2

I want to move A2 to E1 and B2 to F1 so Record 1 is on one line.
The present structure now is first record:
A1 B1 C1 D1
A2 B2
Line 3 Blank line and the next line (4) is the second record.
A4 B4 C4 D4
A5 B5
Line 6 Blank line
etc.

There are 2600 records like this. How can I correct this problem, automated,
if possible.
Thanks,
Dan
 
D

Dave Peterson

It won't be too bad manually.

Put this in E1:
=IF(MOD(ROW(),3)=1,A2,NA())

Put this in F1:
=IF(MOD(ROW(),3)=1,B2,NA())

And drag down your 2600 rows.

You'll end up with errors on row 2,3, 5,6, 8,9, ...

Now you can select columns E:F and
edit|copy
edit|paste special|Values

Select column E
edit|goto|special
constants (but only leave errors checked)
rightclick on any of the selected cells and choose delete
delete entire row.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top