Hello All.

I am looking for a macro that will transpose the text in cells into a single column, but skipping blank cells and skipping cells with specific text.

Basically, I have a 8 by 12 array of cells. Each cell is either "Standard", "Blank", some other string of text, or blank.

I would like to take the 8 x 12 array and transpose it into a single column, but skip over the blank cells or the cells containing "Standard" or "Blank".

Any suggestions or help would be greatly appreciated!