如图所示,把B、C、D、E、F列中的内容放到A列的单元格中,并且不同内容间用逗号隔开,如果后面有几列单元格无内容则后面的就不用逗号隔开,即不能出现形如这种的内容:“M01,F02,M02,,”而是后面的两个逗号不显示。
感谢,此为正解,还没验证,谢谢
此回答没有满足问题需要,如果内容为空,后面还是会有逗号
=b1&if(c1="","",","&c1)&if(d1="","",","&d1)&if(e1="","",","&e1)&if(f1="","",","&f1)