姓名:A2=INDEX(Sheet1!D:D,SMALL(IF(Sheet1!D$1:D$500<>"",ROW(A$1:A$500),4^8),ROW(A1)))&""再同时按下CTRL+Shift+Enter得到数组公式;
身份证号:B2=INDEX(Sheet1!J:J,SMALL(IF(Sheet1!D$1:D$500<>"",ROW(A$1:A$500),4^8),ROW(A1)))&""再同时按下CTRL+Shift+Enter得到数组公式;
电话号码:C2=INDEX(Sheet1!K:K,SMALL(IF(Sheet1!J$1:J$500="联系方式",ROW(A$1:A$500),4^8),ROW(A1)))&""再同时按下CTRL+Shift+Enter得到数组公式;
选定A2:C2下拉即可.
温馨提示:答案为网友推荐,仅供参考