Prevent a value to occupy an empty array

[ha101]

Hi,

How do i prevent a value to occupy an empty array?

For e.g. I have

Alex John
123456
75641441

If i delete John away, the following will be

Alex 123456
75641441

I do not want the number 123456 to occupy the empty array. So how do i prevent it from happening? Please advice.

[Savatage]

Are you saying you want to get rid of the blank?

then check out

COMPRESSARRAY Function

http://msdn.microsoft.com/en-us/library/dd301425.aspx