Copy non-blank cells in a range and paste all into a single column

Hi, all! I did some searching on the Forum and wasn't able to find an answer that fits this particular situation. I have a large data set of disease types spread across many different columns. I'm trying to take the entire range, copy the non-blank ones (i.e. the cells that contain a disease type), and paste this entire range into a single column. I can do everything except for the pasting into a single column. Kutools lets me copy all the non-blank cells, but then it pastes them into the same configuration as they were originally written (i.e. in a bunch of different columns), when what I need for further analysis is to have all the data in one column. Any ideas? Thanks in advance!

That worked like a charm. Thanks very much!