Arrange cells by ignoring blanks

[jason21nz]

I have a row of data that is organised the following way:

Example A, Blank Cell, Blank Cell, Example B, Blank Cell, Blank Cell, Example C......etc

The number of blank cells between values varies.

I want to copy cells into a new sheet in the format:

Example A, Example B, Example C

I can use =MATCH(TRUE,INDEX((A1:Z1<>""),0),0) to find 'Example A' in the row, but its not really working for subsequent cells i.e. "find the second non blank cell"

Thanks,

Jason