怎么才能快速整理图2中的格式内容?
E2è¾å ¥
=INDEX($B:$B,SMALL(IF($A$2:$A$10=$D2,ROW($2:$10),100),COLUMN(A1)))&""
æ°ç»å ¬å¼ï¼å æä½CTRL+SHIFT,æåå车ï¼ä½¿å¾ç¼è¾æ å ¬å¼ä¸¤ç«¯åºç°è±æ¬å·{ }
å ¬å¼ä¸æåå³æå°æ æ°æ®