How to consolidate the data row by same column

[okl]

Hi there

Below is example that i want to achieve by grouping column A and B

example column E will group the "AB" and with all the email addresses seperated by ; in column F

 

[SunnyAlv]

try this

=TEXTSPLIT(TEXTJOIN(";",,F2:F4),,";")

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[okl]

try this

=TEXTSPLIT(TEXTJOIN(";",,F2:F4),,";")

hi

what want to achieve is under column E and F, column A and B is the data to do matching

 

[okl]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Hi

365 , updated in my profile!

 

[Fluff]

365 , updated in my profile!

Thanks for that.
How about in E2

=UNIQUE(FILTER(A2:A100,A2:A100<>""))

and in F2

=MAP(E2#,LAMBDA(br,TEXTJOIN("; ",,FILTER(B2:B100,A2:A100=br))))