①新建一个表(原表名为:源)②新表A列为(以A2为例,A1为标题):=INDIRECT("a"&TEXT(roundup((row()-1)/3,0),0))新表B列为(以B2为例,B1为标题):=INDIRECT("b"&TEXT(roundup((row()-1)/3,0),0))③新表C列为(以C2为例,C1为标题):=INDIRECT("R1C"&TEXT(mod(row()-2,3)+3,0),0)④新表D列为(以D2为例,D1为标题):=INDIRECT("R"&TEXT(roundup((row()-1)/3,0),0)&"C"&TEXT(mod(row()-2,3)+3,0),0)⑤选 |