=IF(ROW()>COUNTA(原始数据!A:A)*2,"",TRIM(IF(MOD(ROW(A1),2),"ap","channel 20mhz ")&SUBSTITUTE(MID(OFFSET(原始数据!A$1,INT(ROW(A2)/2)-1,),MOD(ROW(A2),2)*8+1,10),"/"," r ")))
=IF(ROW()>COUNTA(原始数据!A:A)*2,"",TRIM(IF(MOD(ROW(A1),2),"ap","channel 20mhz ")&SUBSTITUTE(MID(OFFSET(原始数据!A$1,INT(ROW(A2)/2)-1,),MOD(ROW(A2),2)*8+1,10),"/"," r ")))