Help populating a value from a cell when another cell in a range is the first non-blank cell

[dmzurmuhlen]

I would like the find the first occurrence of a non-blank cell, then populate the value from another cell. I have a row with dates (6/1/15, 7/1/15, 8/1/15, etc.). Then I have a row with values (some blank). I want to build a formula that will populate the date the first non-blank cell is encountered. I have it working with a massive IF function, but it's cumbersome because I have a lot of columns.

Here's what's working now:
=IF(AK605>0,$AK$2,(IF(AL605>0,$AL$2,(IF(AM605>0,$AM$2,(IF(AN605>0,$AN$2,(IF(AO605>0,$AO$2,(IF(AP605>0,$AP$2,(IF(AQ605>0,$AQ$2,(IF(AR605>0,$AR$2,(IF(AS605>0,$AS$2,(IF(AT605>0,$AT$2,(IF(AU605>0,$AU$2,(IF(AV605>0,$AV$2,(IF(AW605>0,$AW$2,(IF(AX605>0,$AX$2,(IF(AY605>0,$AY$2,(IF(AZ605>0,$AZ$2,(IF(BA605>0,$BA$2,(IF(BB605>0,$BB$2,(IF(BC605>0,$BC$2,(IF(BD605>0,$BD$2,(IF(BE605>0,$BE$2,(IF(BF605>0,$BF$2,(IF(BG605>0,$BG$2,(IF(BH605>0,$BH$2,(IF(BI605>0,$BI$2,(IF(BJ605>0,$BJ$2,(IF(BK605>0,$BK$2,(IF(BL605>0,$BL$2,(IF(BM605>0,$BM$2,(IF(BN605>0,$BN$2,(IF(BO605>0,$BO$2,(IF(BP605>0,$BP$2,(IF(BQ605>0,$BQ$2,(IF(BR605>0,$BR$2,(IF(BS605>0,$BS$2,(IF(BT605>0,$BT$2,(IF(BU605>0,$BU$2,(IF(BV605>0,$BV$2,(IF(BW605>0,$BW$2,(IF(BX605>0,$BX$2,(IF(BY605>0,$BY$2,(IF(BZ605>0,$BZ$2,(IF(CA605>0,$CA$2,(IF(CB605>0,$CB$2,(IF(CC605>0,$CC$2,(IF(CD605>0,$CD$2,(IF(CE605>0,$CE$2,(IF(CF605>0,$CF$2,(IF(CG605>0,$CG$2,"")))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

Anyone have suggestions on how to simplify this?