Hi,

Thanks. The rule is:

Avoid the blanks and fill the range, giving preference to the right most
column towards left.

I hope it is clear.

Jaleel



"Toppers" wrote:

What are the "rules" for moving the data?

"Jaleel" wrote:

I have some figures from Cell A1 to Cell C4 like this:

A B C
5 3 8
3 7
8

Is it possible to get these figures from Cell E1 to Cell G4 like this:

A B C
5 3 8
3 7
8

This option is required to solve another problem. Can anyone help me?
Thanks in advance.

Jaleel