lookup function over even number columns

[leewcrawford]

I have a work sheet that has names in columns A1-H1.
I would like a formula that will in effect concatenate the falue in A1-H1 if there is data in the cell directly below it. The problem is that I need to skip every other column. I have the following formula however it will not skip columns.

=IF(COUNTBLANK(A2:H2)<COLUMNS(A2:H2),LOOKUP(2,1/(A2:H2<>""),A1:H1&" "&A2:H2),"")

Perhaps this can be done with a lookup function?

I have attached an example. Please Help.

[martindwilson]

see here similar thread today
http://www.excelforum.com/excel-gene...atenation.html