Need to merge cells in a single column based on value of another column

[imeade]

Hello,

I have data in two columns A & B, I need to merge the rows in Column B into a single cell based on the value in Column A with a "-" separating them, and drop into columns C & D, please see below:

Column A	Column B		Column C	Column D
Data			Macro Output
Account	Name		Account	Name
12345​	ABC		12345​	ABC-Jeff-CDE-Bob
12345​	Jeff		67890​	Kyle-JKL-Ruth-XYZ
12345​	CDE
12345​	Bob
67890​	Kyle
67890​	JKL
67890​	Ruth
67890​	XYZ

Thanks in advance!

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E
1	Account	Name		Account	Name
2	12345	ABC		12345	ABC-Jeff-CDE-Bob
3	12345	Jeff		67890	Kyle-JKL-Ruth-XYZ
4	12345	CDE
5	12345	Bob
6	67890	Kyle
7	67890	JKL
8	67890	Ruth
9	67890	XYZ
10
Code

Cell Formulas
Range	Formula
D2:E3	D2	=LET(u,UNIQUE(FILTER(A2:A100,A2:A100<>"")),HSTACK(u,BYROW(u,LAMBDA(br,TEXTJOIN("-",,FILTER(B2:B100,A2:A100=br))))))
Dynamic array formulas.

 

[imeade]

How about

Fluff.xlsm
	A	B	C	D	E
1	Account	Name		Account	Name
2	12345	ABC		12345	ABC-Jeff-CDE-Bob
3	12345	Jeff		67890	Kyle-JKL-Ruth-XYZ
4	12345	CDE
5	12345	Bob
6	67890	Kyle
7	67890	JKL
8	67890	Ruth
9	67890	XYZ
10
Code

Cell Formulas
Range	Formula
D2:E3	D2	=LET(u,UNIQUE(FILTER(A2:A100,A2:A100<>"")),HSTACK(u,BYROW(u,LAMBDA(br,TEXTJOIN("-",,FILTER(B2:B100,A2:A100=br))))))
Dynamic array formulas.

Thanks but that doesn't seem to work on my excel, I should have also noted I was looking for a macro, will update my post, thanks again

 

[Fluff]

Do you really need a macro?
If you don't have Hstack then another option is

Fluff.xlsm
	A	B	C	D	E
1	Account	Name		Account	Name
2	12345	ABC		12345	ABC-Jeff-CDE-Bob
3	12345	Jeff		67890	Kyle-JKL-Ruth-XYZ
4	12345	CDE
5	12345	Bob
6	67890	Kyle
7	67890	JKL
8	67890	Ruth
9	67890	XYZ
10
Code

Cell Formulas
Range	Formula
D2:D3	D2	=UNIQUE(FILTER(A2:A100,A2:A100<>""))
E2:E3	E2	=TEXTJOIN("-",,FILTER($B$2:$B$100,$A$2:$A$100=D2))
Dynamic array formulas.

 

[imeade]

Do you really need a macro?
If you don't have Hstack then another option is

Fluff.xlsm
	A	B	C	D	E
1	Account	Name		Account	Name
2	12345	ABC		12345	ABC-Jeff-CDE-Bob
3	12345	Jeff		67890	Kyle-JKL-Ruth-XYZ
4	12345	CDE
5	12345	Bob
6	67890	Kyle
7	67890	JKL
8	67890	Ruth
9	67890	XYZ
10
Code

Cell Formulas
Range	Formula
D2:D3	D2	=UNIQUE(FILTER(A2:A100,A2:A100<>""))
E2:E3	E2	=TEXTJOIN("-",,FILTER($B$2:$B$100,$A$2:$A$100=D2))
Dynamic array formulas.

That works, thanks!

 

[Fluff]

You're welcome & thanks for the feedback.