Find first non-empty cell in a spreadsheet row and copy the content to a separate column

I've got a fairly simple Excel spreadsheet with many rows and columns of data. Each row contains a single non-empty cell (all the rest being empty). However the column may differ row by row.

Is there a simple way to search the rows and present the content of the non-empty cell in a single column. I have tried concatenate but wondered if there is another formulae that I can use.