Try the following instead...

A2, copied across:

=IF(COLUMNS($A2:A2)<=COLUMNS($A$1:$M$1)-COUNTBLANK($A$1:$M$1),INDEX($A$1:
$M$1,SMALL(IF($A$1:$M$1<"",COLUMN($A$1:$M$1)-COLUMN($A$1)+1),COLUMNS($A2
:A2))),"")

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
grime wrote:

Bob and Dom,

Thanks for the reply, but neither formula did the trick. I entered
both in as array formulas, and Bob, I even changed your BlanksRanges to
BlanksRange.

To summarize again, I have data in a range A1:M1 that contains blanks
and I want the list from row 1 into row 2 (A2:M2) without blanks.

Thanks again.