Finding numbers in a row

Hi,

So that we can understand your requirement without confusion would you upload an example with a few rows of the typical results that you expect explaining where necessary why you get the results you show?

Regards

Based on your sample, maybe...
=IFERROR(SMALL($E2:$K2,COLUMN(A1)),"")
copied down and across

If the numbers are not ascending left to right in Columns E:K, and you need them in the order they occur then try this.
In A2
Confirm with Ctrl+Shift+Enter not just Enter Before dragging Across and Down.

Formula:

=IFERROR(INDEX(2:2,1,SMALL(INDEX(IF(ISNUMBER($E2:$K2),COLUMN($E2:$K2),""),1,),COLUMNS($A:A))),"")

Note
Your profile is 2003 but the workbook you supplied is 2007 or above.
If you need this to work with 2003 then use this CSE array formula

Formula:

=IF(ISERROR(INDEX(2:2,1,SMALL(INDEX(IF(ISNUMBER($E2:$K2),COLUMN($E2:$K2),""),1,),COLUMNS($A:A)))),"",INDEX(2:2,1,SMALL(INDEX(IF(ISNUMBER($E2:$K2),COLUMN($E2:$K2),""),1,),COLUMNS($A:A))))