假设坐标工作表标签为Sheet1,右表N6公式:
=IFERROR(INDEX(Sheet1!$M$1:$Q$20,INT(SMALL(IF(Sheet1!$N$6:$Q$20<>"",ROW($B$6:$E$20)+COLUMN($B$6:$E$20)/1000,""),ROW(A1)*20-20+COLUMN(A1))),MOD(SMALL(IF(Sheet1!$N$6:$Q$20<>"",ROW($B$6:$E$20)+COLUMN($B$6:$E$20)/1000,""),ROW(A1)*20-20+COLUMN(A1)),1)*1000),"")
ctrl+shift+回车,右拉到AG6后下拉。