"W. Watson" wrote
... Is it possible to expand an array based on the
absence of some data. In particular, suppose I have:

1 x
3 z
4 m
5 p
6 c

But need to have a record for every sequential digit from 1 to 6, so that
I have:

1 x
2
3 z
4 m
5 p
6 c

Try this ..

Assume data below is in A1:B5
1 x
3 z
4 m
5 p
6 c

Put in D1:
=IF(ROWS($A$1:A1)<=MIN(A:A),MIN(A:A),IF(ROWS($A$1: A1)MAX(A:A),"",ROWS($A$1:
A1)))

Put in E1:
=IF(ISNA(MATCH(D1,A:A,0)),"",INDEX(B:B,MATCH(D1,A: A,0)))

Select D1:E1, fill down until blanks appear in cols D & E,
signalling completion of fill

You'll get in D1:E6:

1 x
2
3 z
4 m
5 p
6 c
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----