Group Vendor Emails

[albertan]

Book2
	D	E	F	G	H	I	J	K
1
2	Initial Format
3	Vendor ID	email
4	12345	a@x.com
5	12345	b@x.com
6	12345	c@x.com
7	12345	d@x.com
8	12345	e@x.com
9	12345	f@x.com
10	12345	j@x.com
11	12345	f@x.com
12	12346	abc@xyz.com
13
14
15	Final Format
16
17	Vendor ID	email
18	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
19	12346	abc@xyz.com
Initial

 

[JGordon11]

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	email		Vendor ID	email
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

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Group data to get multiple email addresses for same vendor
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[albertan]

Thank you!