Help to get characters from different cells based on same character

[gargilang]

Hello, I would like to know if it's possible to have some formula to get the specific characters from two or three different cells based on same character in it. I am using this formula at the moment

=LEFT(A2,FIND("_",A2)-1)

to get the characters I want. for example below table:

1_aaaa_x	1
2_aaaa_y	2
3_bbbb_x	3

Now what I want is something like this:

1_aaaa_x	1, 2
2_aaaa_y	2, 1
3_bbbb_x	3, 4, 5
4_bbbb_y	4, 3, 5
5_bbbb_z	5, 3, 4

And now if it's not too much to ask already, is it also possible to have the formula to add "&" to the cell, for example:

1_aaaa_x	1 & 2
2_aaaa_y	2 & 1
3_bbbb_x	3, 4 & 5
4_bbbb_y	4, 3 & 5
5_bbbb_z	5, 3 & 4

if not than it's totally okay as this is only for aesthetic.

I hope it makes sense. Kindly let me know if it's possible. Thank you for your help in advance.

 

[Fluff]

Ok, try

=SUBSTITUTE(TEXTJOIN(", ",,A2,IF(($B$2:$B$10=B2)*($A$2:$A$10<>A2),$A$2:$A$10,"")),","," &",MAX(1,COUNTIFS($B$2:$B$10,B2)-1))

 

[gargilang]

Ok, try

=SUBSTITUTE(TEXTJOIN(", ",,A2,IF(($B$2:$B$10=B2)*($A$2:$A$10<>A2),$A$2:$A$10,"")),","," &",MAX(1,COUNTIFS($B$2:$B$10,B2)-1))

This is it! Thank you so ever very much! Once again...

 

[Fluff]

You're welcome & thanks for the feedback.