Trying to figure out if there is a way that I can extract all the values in each column (Column B:M). I tried the array formula =INDEX(C15:C66,MATCH(TRUE,C15:C66<>0,)), and because the starting row in each column is different, so my formula doesn't work.
I have attached a simple workbook. Any help is appreciated.
Bookmarks