可以用一段VBA程序解决sub abc()dim shta as worksheet, shtb as worksheetdim a as range, b as range, i
set shta = worksheets(原始工作表名称)
set shtb = worksheets(转换后工作表名称)
for each a in shta.range(shta.range("A1"), shta.range("A1").end(xldown))
set b= shtb.range("A65535").end(xlup).offset(1,0)
for i...