如上图,假设第一张表为SHEET1,第二张表为SHEET2,则在SHEET2的A2输入:
=IF(COLUMN()/2>SUMPRODUCT(SMALL(IF(Sheet1!$A$1:$A$9999="户主",ROW($1:$9999),10^9),ROW(1:2))*{-1;1}),"",OFFSET(Sheet1!$B$2,INT((COLUMN()-1)/2)+SMALL(IF(Sheet1!$A$1:$A$9999="户主",ROW($1:$9999),10^9),ROW(1:1))-2,MOD(COLUMN()-1,2),,))
数组公式,按CTRL+SHIFT+回车结束,右拉下拉填充
追问公示这么复杂?