Returning Non-blank Cells from a Row Section to another Row Section on the Same Row

Hello everyone,

I am using Microsoft Excel 2007.
How can I return non-blank cells from a row section to another row section on the same row with formulas?
From Column B to Column H I would like to have the non-blank cells all listed one after one.
From Column I to Column O contains the data to be listed.
And each row has its own set of data to be listed.
The attached excel file simulates the the expected output.
I have been looking for the relevant information online but after a lot of testings all the existing similar solutions do not seem to work for me.
I am not sure about the reason but I guess maybe it is because the existing formulas available online return non-blank cells from a column section to a column section rather than from a row section to a row section.

Thanks a lot,
Lawrence

Assuming you have headers, select B2 and paste this ARRAY FORMULA in the formula bar:
=IFERROR(INDEX($A2:$O2,,SMALL(IF($I2:$O2<>"",COLUMN($I2:$O2)),COLUMNS($A2:A2))),"")

Now press CTRL+SHIFT+ENTER to confirm (as always required with array formulae), then drag across to H2.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee