Create a list of uppercase data from a range excluding blanks and errors

I have a list generator that creates a set of data in a multi-column & row dataset. I would like a formula to create a list of the alpha data points only which excludes blanks and any errors.

Example:

AA DD
#N/A
BB 23 EE FF
#N/A
#N/A 12 GG
CC


Results:

AA
BB
CC
DD
EE
FF
GG


Thanks,

PAexcel