主题：[求助]列数据如何在它表中转为行数据？

请老师帮我写出,数据复制后,"数据排序"列中出现按从小到大的自动排序的公式.谢谢,.

Concat(if(Instr("00",[复制数据])>-1,"|00",""),if(Instr("01",[复制数据])>-1,"|01",""),if(Instr("02",[复制数据])>-1,"|02",""),if(Instr("03",[复制数据])>-1,"|03",""),if(Instr("04",[复制数据])>-1,"|04",""),if(Instr("05",[复制数据])>-1,"|05",""),if(Instr("06",[复制数据])>-1,"|06",""),if(Instr("07",[复制数据])>-1,"|07",""),if(Instr("08",[复制数据])>-1,"|08",""),if(Instr("09",[复制数据])>-1,"|09",""),if(Instr("10",[复制数据])>-1,"|10",""),if(Instr("11",[复制数据])>-1,"|11",""),if(Instr("12",[复制数据])>-1,"|12",""),if(Instr("13",[复制数据])>-1,"|13",""),if(Instr("14",[复制数据])>-1,"|14",""),if(Instr("15",[复制数据])>-1,"|15",""),if(Instr("16",[复制数据])>-1,"|16",""),if(Instr("17",[复制数据])>-1,"|17",""),if(Instr("18",[复制数据])>-1,"|18",""),if(Instr("19",[复制数据])>-1,"|19",""),if(Instr("20",[复制数据])>-1,"|20",""),if(Instr("21",[复制数据])>-1,"|21",""),if(Instr("22",[复制数据])>-1,"|22",""),if(Instr("23",[复制数据])>-1,"|23",""),if(Instr("24",[复制数据])>-1,"|24",""),if(Instr("25",[复制数据])>-1,"|25",""),if(Instr("26",[复制数据])>-1,"|26",""),if(Instr("27",[复制数据])>-1,"|27",""),if(Instr("28",[复制数据])>-1,"|28",""),if(Instr("29",[复制数据])>-1,"|29",""),if(Instr("30",[复制数据])>-1,"|30",""),if(Instr("31",[复制数据])>-1,"|31",""),if(Instr("32",[复制数据])>-1,"|32",""),if(Instr("33",[复制数据])>-1,"|33",""),if(Instr("34",[复制数据])>-1,"|34",""),if(Instr("35",[复制数据])>-1,"|35",""),if(Instr("36",[复制数据])>-1,"|36",""),if(Instr("37",[复制数据])>-1,"|37",""),if(Instr("38",[复制数据])>-1,"|38",""),if(Instr("39",[复制数据])>-1,"|39",""),if(Instr("40",[复制数据])>-1,"|40",""),if(Instr("41",[复制数据])>-1,"|41",""),if(Instr("42",[复制数据])>-1,"|42",""),if(Instr("43",[复制数据])>-1,"|43",""),if(Instr("44",[复制数据])>-1,"|44",""),if(Instr("45",[复制数据])>-1,"|45",""),if(Instr("46",[复制数据])>-1,"|46",""),if(Instr("47",[复制数据])>-1,"|47",""),if(Instr("48",[复制数据])>-1,"|48",""),if(Instr("49",[复制数据])>-1,"|49",""))

数据排序所有列通用公式：

Split([辅助],"|",col)

         这是一个通用案例，数据长度可以为1～N个，数值大小随意！

       是啊，我疏忽了，将操作公式改为按钮公式即可！