求助各位大神,有没有哪种途径可以把左边的数据拆分成右边的样子?编号需要跟着变化,就是假设一个编号里面有三个科室,那拆分后这个编号一行一个科室,就是需要体现同样的编号不同的科室。
见例表,加个辅助列,e2=LEN(D2)-LEN(SUBSTITUTE(D2,",",))+1下拉,g2=c2,g3=IF(ROW(A2)>SUM(E:E),"",IF(ROW()-MATCH(G2,G:G,0)<VLOOKUP(G2,C:E,3,0),G2,INDEX(C:C,MATCH(G2,C:C,0)+1)))下拉
最后h2=IF(G2="","",LEFT(MID(","&VLOOKUP(G2,C:D,2,0),FIND("+",SUBSTITUTE(","&VLOOKUP(G2,C:D,2,0),",","+",ROW()-MATCH(G2,G:G,0)+1))+1,50)&",",FIND(",",MID(","&VLOOKUP(G2,C:D,2,0),FIND("+",SUBSTITUTE(","&VLOOKUP(G2,C:D,2,0),",","+",ROW()-MATCH(G2,G:G,0)+1))+1,50)&",")-1))下拉