所有列数据,合并到同一个列数据显示

所有列数据,合并到同一个列数据显示

 

 

="'"&A1&"'"&","

&"'"&B1&"'"&","

&"'"&C1&"'"&","

&"'"&D1&"'"&","

&"'"&E1&"'"&","

&"'"&F1&"'"&","

&"'"&G1&"'"&","

&"'"&H1&"'"&","

&"'"&I1&"'"&","

&"'"&J1&"'"&","

&"'"&K1&"'"&","

&"'"&L1&"'"&","

&"'"&M1&"'"&","

&"'"&N1&"'"&","

&"'"&O1&"'"&","

&"'"&P1&"'"&","

&"'"&Q1&"'"&","

&"'"&R1&"'"&","

&"'"&S1&"'"&","

&"'"&T1&"'"&","

&"'"&U1&"'"&","

&"'"&V1&"'"&","

&"'"&W1&"'"&","

&"'"&X1&"'"&","

&"'"&Y1&"'"&","

&"'"&Z1&"'"&","

&"'"&AA1&"'"&","

&"'"&AB1&"'"&","

&"'"&AC1&"'"&","

&"'"&AD1&"'"&","

&"'"&AE1&"'"&","

&"'"&AF1&"'"&","

&"'"&AG1&"'"&","

&"'"&AH1&"'"&","

&"'"&AI1&"'"&","

&"'"&AG1&"'"&","

&"'"&AK1&"'"&","

&"'"&AL1&"'"&","

&"'"&AM1&"'"&","

&"'"&AN1&"'"&","

&"'"&AO1&"'"&","

&"'"&AP1&"'"&","

&"'"&AQ1&"'"&","

&"'"&AR1&"'"&","

&"'"&AS1&"'"&","

&"'"&AT1&"'"&","

&"'"&AU1&"'"&","

&"'"&AV1&"'"&","

&"'"&AW1&"'"&","

&"'"&AX1&"'"&","

&"'"&AY1&"'"&","

&"'"&AZ1&"'"&","

&"'"&BA1&"'"&","

&"'"&BB1&"'"&","

&"'"&BC1&"'"&","

&"'"&BD1&"'"&","

&"'"&BE1&"'"&","

&"'"&BF1&"'"&","

&"'"&BG1&"'"&","

&"'"&BH1&"'"&","

&"'"&BI1&"'"&","

&"'"&BG1&"'"&","

&"'"&BK1&"'"&","

&"'"&BL1&"'"&","

&"'"&BM1&"'"&","

&"'"&BN1&"'"&","

&"'"&BO1&"'"&","

&"'"&BP1&"'"&","

&"'"&BQ1&"'"&","

&"'"&BR1&"'"&","

&"'"&BS1&"'"&","

&"'"&BT1&"'"&","

&"'"&BU1&"'"&","

&"'"&BV1&"'"&","

&"'"&BW1&"'"&","

&"'"&BX1&"'"&","

&"'"&BY1&"'"&","

&"'"&BZ1&"'"&","

&"'"&CA1&"'"&","

&"'"&CB1&"'"&","

&"'"&CC1&"'"&","

&"'"&CD1&"'"&","

&"'"&CE1&"'"&","

&"'"&CF1&"'"&","

&"'"&CG1&"'"&","

&"'"&CH1&"'"&","

&"'"&CI1&"'"&","

&"'"&CG1&"'"&","

&"'"&CK1&"'"&","

&"'"&CL1&"'"&","

&"'"&CM1&"'"&","

&"'"&CN1&"'"&","

&"'"&CO1&"'"&","

&"'"&CP1&"'"&","

&"'"&CQ1&"'"&","

&"'"&CR1&"'"&","

&"'"&CS1&"'"&","

&"'"&CT1&"'"&","

&"'"&CU1&"'"&","

&"'"&CV1&"'"&","

&"'"&CW1&"'"&","

&"'"&CX1&"'"&","

&"'"&CY1&"'"&","

&"'"&CZ1&"'"&","

&"'"&DA1&"'"&","

&"'"&DB1&"'"&","

&"'"&DC1&"'"&","

&"'"&DD1&"'"&","

&"'"&DE1&"'"&","

&"'"&DF1&"'"&","

&"'"&DG1&"'"&","

&"'"&DH1&"'"&","

&"'"&DI1&"'"&","

&"'"&DG1&"'"&","

&"'"&DK1&"'"&","

&"'"&DL1&"'"&","

&"'"&DM1&"'"&","

&"'"&DN1&"'"&","

&"'"&DO1&"'"&","

&"'"&DP1&"'"&","

&"'"&DQ1&"'"&","

&"'"&DR1&"'"&","

&"'"&DS1&"'"&","

&"'"&DT1&"'"&","

&"'"&DU1&"'"&","

&"'"&DV1&"'"&","

&"'"&DW1&"'"&","

&"'"&DX1&"'"&","

&"'"&DY1&"'"&","

&"'"&DZ1&"'"&","

&"'"&EA1&"'"&","

&"'"&EB1&"'"&","

&"'"&EC1&"'"&","

&"'"&ED1&"'"&","

&"'"&EE1&"'"&","

&"'"&EF1&"'"&","

&"'"&EG1&"'"&","

&"'"&EH1&"'"&","

&"'"&EI1&"'"&","

&"'"&EG1&"'"&","

&"'"&EK1&"'"&","

&"'"&EL1&"'"&","

&"'"&EM1&"'"&","

&"'"&EN1&"'"&","

&"'"&EO1&"'"&","

&"'"&EP1&"'"&","

&"'"&EQ1&"'"&","

&"'"&ER1&"'"&","

&"'"&ES1&"'"&","

&"'"&ET1&"'"&","

&"'"&EU1&"'"&","

&"'"&EV1&"'"&","

&"'"&EW1&"'"&","

&"'"&EX1&"'"&","

&"'"&EY1&"'"&","

&"'"&EZ1&"'"&","

&"'"&FA1&"'"&","

&"'"&FB1&"'"&","

&"'"&FC1&"'"&","

&"'"&FD1&"'"&","

&"'"&FE1&"'"&","

&"'"&FF1&"'"&","

&"'"&FG1&"'"&","

&"'"&FH1&"'"&","

&"'"&FI1&"'"&","

&"'"&FG1&"'"&","

&"'"&FK1&"'"&","

&"'"&FL1&"'"&","

&"'"&FM1&"'"&","

&"'"&FN1&"'"&","

&"'"&FO1&"'"&","

&"'"&FP1&"'"&","

&"'"&FQ1&"'"&","

&"'"&FR1&"'"&","

&"'"&FS1&"'"&","

&"'"&FT1&"'"&","

&"'"&FU1&"'"&","

&"'"&FV1&"'"&","

&"'"&FW1&"'"&","

&"'"&FX1&"'"&","

&"'"&FY1&"'"&","

&"'"&FZ1&"'"&","

&"'"&GA1&"'"&","

&"'"&GB1&"'"&","

&"'"&GC1&"'"&","

&"'"&GD1&"'"&","

&"'"&GE1&"'"&","

&"'"&GF1&"'"&","

&"'"&GG1&"'"&","

&"'"&GH1&"'"&","

&"'"&GI1&"'"&","

&"'"&GG1&"'"&","

&"'"&GK1&"'"&","

&"'"&GL1&"'"&","

&"'"&GM1&"'"&","

&"'"&GN1&"'"&","

&"'"&GO1&"'"&","

&"'"&GP1&"'"&","

&"'"&GQ1&"'"&","

&"'"&GR1&"'"&","

&"'"&GS1&"'"&","

&"'"&GT1&"'"&","

&"'"&GU1&"'"&","

&"'"&GV1&"'"&","

&"'"&GW1&"'"&","

&"'"&GX1&"'"&","

&"'"&GY1&"'"&","

&"'"&GZ1&"'"&","

posted @ 2022-06-20 17:11  tiansc  阅读(40)  评论(0编辑  收藏  举报