ç¨å ¬å¼çè¯ï¼æ¯æ¯è¾å¤æçï¼ä¸Excelçæ¬å¿ é¡»æ¯2109æ365çæ¬ï¼å¦å¾ï¼å ¬å¼ï¼
=TEXTJOIN(,,IF(MATCH(MID(PHONETIC(B1:B8),ROW(INDIRECT("1:"&LEN(PHONETIC(B1:B8)))),1),MID(PHONETIC(B1:B8),ROW(INDIRECT("1:"&LEN(PHONETIC(B1:B8)))),1),)=ROW(INDIRECT("1:"&LEN(PHONETIC(B1:B8)))),MID(PHONETIC(B1:B8),ROW(INDIRECT("1:"&LEN(PHONETIC(B1:B8)))),1),""))
åæ¶æCtrl+Shift+Enterä¸é®è¾å ¥æ°ç»å ¬å¼
追çç¨Power Queryåå¯è½»æå®ç°ãå¦å¾ï¼ææ°æ®å¯¼å ¥å°Power Queryä¸
å ååï¼æææåå æ ¼åæåªä¸ä¸ªå符ï¼ä¸ååæ¶ç´æ¥åå¨è¡ä¸
对è¡ä¸çå符å é¤éå¤é¡¹
对å符æåº
å°è¡è½¬ç½®æå
å并å
ä¸è½½å并åçæ°æ®å°Excelå·¥ä½è¡¨ä¸
æææä½è¿ç¨çMè¯è¨ä¸ºï¼
let
æº = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
æ´æ¹çç±»å = Table.TransformColumnTypes(æº,{{"å1", type text}}),
ç¨ä½ç½®åå = Table.ExpandListColumn(Table.TransformColumns(æ´æ¹çç±»å, {{"å1", Splitter.SplitTextByRepeatedLengths(1), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "å1"),
æ´æ¹çç±»å1 = Table.TransformColumnTypes(ç¨ä½ç½®åå,{{"å1", type text}}),
å é¤çå¯æ¬ = Table.Distinct(æ´æ¹çç±»å1),
æåºçè¡ = Table.Sort(å é¤çå¯æ¬,{{"å1", Order.Ascending}}),
转置表 = Table.Transpose(æåºçè¡),
å并çå = Table.CombineColumns(转置表,{"Column1", "Column2", "Column3", "Column4", "Column5", "Column6"},Combiner.CombineTextByDelimiter("", QuoteStyle.None),"ç»æ")
in
å并çå
å ¶ä¸âæ´æ¹çç±»åâæ¯Power Queryèªå¨æ·»å çã