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...