Extract Non-Blank Cells from an array into a single column.

I would like a new tab created in my spreadsheet to only show the (non-blank) data from an array, expressed in a single column. Array is 12 by 50 cells, and most of it is blank. A new tab should be created with a single-column, multiple row data...that automatically updates itself, based on any changes within the array. The table should not need updated as it is automatically tied to any changes made in the array. There can only be one extracted cell's information per row of this new tab's column. There can be no empty rows in this new tab's column. I would prefer that the color of the text be unaffected. So red text in the array is presented as red text in the new table, and black text stays black. The array is AH1:CB50