Hi
Paste the formula below to h2 cell and drag it down
=INDEX(A2:G2,MATCH(TRUE,IF(NOT(ISERROR(A2:G2)),TRUE),0))

After entering formula press Ctrl+Shift+Enter, nbot only enter.
Good luck