将公式
=Sheet1!$B$1&": "&VLOOKUP(B2,Sheet1!$A:$F,2,)&", "&Sheet1!$C$1&": "&VLOOKUP(B2,Sheet1!$A:$F,3,)&", "&Sheet1!$D$1&": "&VLOOKUP(B2,Sheet1!$A:$F,4,)&", "&Sheet1!$E$1&": "&VLOOKUP(B2,Sheet1!$A:$F,5,)&", "&Sheet1!$F$1&": "&VLOOKUP(B2,Sheet1!$A:$F,6,)
粘贴至D2单元格,对准右下角,光标成"+"状时双击 ,如图: