or if there is no more than 5 EANs
// Table1
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Text = Table.TransformColumnTypes(Source,{{"Product Article ID", type text}, {"EAN", type text}}),
Grp = Table.Group(Text, {"Product Article ID"}, {{"All", each _, type table}}),
List = Table.AddColumn(Grp, "EAN", each [All][EAN]),
Ext = Table.TransformColumns(List, {"EAN", each Text.Combine(List.Transform(_, Text.From), ","), type text}),
Split = Table.SplitColumn(Ext, "EAN", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), 5 )
in
Split
Product Article ID |
EAN.1 |
EAN.2 |
EAN.3 |
EAN.4 |
EAN.5 |
55a62da4-4f82-4fc4-afbc-c3fbdc40e1d2 |
8591454005939 |
|
|
|
|
b04fa022-79bc-41ae-860b-b81cf33385b9 |
5703538244988 |
|
|
|
|
d9e60527-9dff-4982-ad3f-1630ffa30386 |
5703538245244 |
|
|
|
|
f596abca-e6bf-4527-b687-476a16565017 |
5713571000205 |
5713571000212 |
|
|
|
517e03c6-432f-4bd8-9796-e9974f2f8b05 |
5703538759819 |
|
|
|
|
e7176d60-a687-4f06-aa94-114e4b355e0b |
5703538759499 |
5703538755903 |
|
|
|
6b2723e9-b36f-457e-8b39-9ffac835be7d |
5703538759994 |
5703538759970 |
|
|
|
c9182c83-761d-4380-a867-42744ef5930d |
5703538759697 |
|
|
|
|
ae87520b-2a1c-443f-a8cc-2c07a82c2652 |
5703538759215 |
|
|
|
|
51fc53ea-5286-4591-abf8-170c7559a6c1 |
5713571001219 |
5713571001202 |
|
|
|
Bookmarks