let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Group = Table.Group(Source, {"Vendor ID"}, {{"email", each Text.Combine(_[email], ";")}})
in
Group
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Vendor ID | Vendor ID | ||||||
2 | 12345 | a@x.com | 12345 | a@x.com;b@x.com;c@x.com;d@x.com;e@x.com;f@x.com;j@x.com;f@x.com | ||||
3 | 12345 | b@x.com | 12346 | abc@xyz.com | ||||
4 | 12345 | c@x.com | ||||||
5 | 12345 | d@x.com | ||||||
6 | 12345 | e@x.com | ||||||
7 | 12345 | f@x.com | ||||||
8 | 12345 | j@x.com | ||||||
9 | 12345 | f@x.com | ||||||
10 | 12346 | abc@xyz.com | ||||||
11 | ||||||||
12 | ||||||||
Sheet1 |