合併格跨表取資料 依日期 (14457)

D2合併格公式=IF((INDIRECT("R[-3]C",)&""="")*(ROW(A1)>1),"",OFFSET(Sheet1!B$1,MATCH(B$3,Sheet1!A:A,)+INT(ROW(A1)/3),)&"")

合併格公式  :公式下D2-->ENTER-->圈選D2:D16(合併格)-->游標放公式上-->ctrl+enter二鍵一起按

G2下拉=IF(MOD(ROW(A3),3),TEXT(OFFSET(Sheet1!B$1,MATCH(B$3,Sheet1!A:A,)+INT(ROW(A3)/3)-1,3-MOD(ROW(A3),3)),"[=] ;[>1];H時MM分"),"")