Skipping Blanks

[F. Lawrence Kulchar]

I want to copy and paste 2 columns of numbers as follows:

A B
1 100
2 50
3 40
4
5 65
6 20 20
7
8 9
9 15
10

In my PASTED TO cells, I want all BLANKS to dissappear.

In other words, the new columns of numbers will not contain any blank cells.

How can I accomplish this please?

Thanks,

FLKulchar

 

[Pete_UK]

You have answers elsewhere - please do not multi-post.

Pete