How to combine multiple column data to single column using formula

Dear Experts

I have data in 9 columns and 1000 number of rows, I need to do is combine these data to single column and skip the blank cells using formula not macros
Attached sample work book for reference

Thanks a lot in advance

Rgds
Krishna

Whitout VBA, I tihnk that it should be something like this:

Array entered.

Please Login or Register  to view this content.

Thanks Paul for your prompt response
Is this possible without array formula, if yes please on that..

Thanks & Rgds
Krishna

See if this works for your data. In the sample it is looking good:

Please Login or Register  to view this content.

Thx Paul, its working fine

Thx Samba, its working fine