哪儿来的?太妙了!可能我学不会,这一大堆公式:
DelFor(Grid,"项目","=","")And eval("CreateGrid(""正转换中,请稍候..."","""+Substitute(ListCols("行列互转"),"|",""",0,""")+""",0)") And CopyRows(Grids) And DelFor(Grids,1, "=" ,"")And SetVariable("%A%",ListFor(Grid,"项目")) And SetVariable("%C%",ListCols(Grid)) And SetVariable("%E%",Rows) And SetVariable("%F%",Cols-1) And eval("RenameCol("+Substitute(Substitute(Mid([%so%],0,Search("|",Substitute([%so%],"|","#",min([%E%],[%F%])))),"|",",1)) And RenameCol("),"&",",cell(")+"))")and If([%F%]>[%E%],eval(mid(Rept("And DeleteCol(Cols)",[%F%]-[%E%]),4)) And AddRows(Grid,[%F%]-[%E%]), eval("AddCol("""+ Substitute(Mid([%A%],Search("|",Substitute([%A%]+"|&","|","/",[%F%]-1))+1),"|",""",0, True )And AddCol(""")+""",0,True)") And eval(mid(Rept("And DelRow(Grid,Rows)",[%E%]-[%F%]),4)))And EvalFor(Grid,1,"Split([%C%],""|"",Row+1)") And eval("EvalFor(Grid,"+Substitute(Substitute(Mid([%si%],0,Search("|",Substitute([%si%],"|","%",Cols- 2))),"|","-1,Row+1,Grids)"")And EvalFor(Grid,"),"&",",""cell(")+"-1,Row+1,Grids)"")") And Select(Rows,1,Rows,Cols) And Do(92) And Do(92)And Last()And RemoveGrid(Grids)
谢谢你!