Quote Originally Posted by AlKey View Post
On your Expected Results sheet enter formula in A1 and drag formula across and down

***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Formula: copy to clipboard 
=IFERROR(INDEX(PROBLEM!A:A,SMALL(IF(PROBLEM!A$1:A$200<>"",ROW(A$1:A$200)),ROWS(A$1:A1))),"")

For Excel (2010, 2013, 2016) use this regular formula
Formula: copy to clipboard 
=IFERROR(INDEX(PROBLEM!A:A,AGGREGATE(15,6,ROW(A$1:A$200)/(PROBLEM!A$1:A$200<>""),ROWS(A$1:A1))),"")
Is there a way for it to not return 0 for blank cells?