|
|
各位大神，请帮忙看看如下表格C2的内容怎么做？
如下表
1. 需要将A2:R2(除C2,F2)的内容汇总进C2内并以","进行分隔，但如果单元格内容为"NA", 则不汇总该字段
2. 单行的单元格数目不固定，可能为A2:R2, 或A2:Z2
当前状态如下:
| Type | Package | Desc | Vendor | MPN | Height | Temp | Interface | Voltage | Current | TYPE | Function | Memory_Size | Fun_Desc | Capacitance | Resistance | Rohs | Remark | | LDO | SOT-223-6 | LDO, TI, TPS78601DCQR,-40 TO 125 DEGREE,NA,NA,NA,NA,OUT CUR=1.5A,NA,NA,NA,NA,ROHS,NA | TI | TPS78601DCQR | 1.8MM | -40 TO 125 DEGREE | NA | NA | NA | NA | OUT CUR=1.5A | NA | NA | NA | NA | ROHS | NA |
期望状态如下:
| Type | Package | Desc | Vendor | MPN | Height | Temp | Interface | Voltage | Current | TYPE | Function | Memory_Size | Fun_Desc | Capacitance | Resistance | Rohs | Remark | | LDO | SOT-223-6 | LDO,TI,TPS78601DCQR,-40 TO 125 DEGREE,OUT CUR=1.5A,ROHS | TI | TPS78601DCQR | 1.8MM | -40 TO 125 DEGREE | NA | NA | NA | NA | OUT CUR=1.5A | NA | NA | NA | NA | ROHS | NA |
|
|
沪公网安备 31011702000001号 沪ICP备11019229号-2
发表于 2017-6-9 09:13