array processing?

[Danny54]

Can I get some ideas on how to process the following data? I have data in sheet 1 that contains two columns. (Make Assigned)
What I'm trying to do is process this data in sheet1 and create the output in sheet2.
In short, find all the unique Make and attach all the unique Assigned names delimited by a ";" to that make
Not certain if excel vba provides a function to handle this or not.
Any help would be appreciated

Thanks

Sheet1
Make	Assigned
chevy	John
ford	john1
buick	john2
chevy	joe
buick	sam
buick	sally
Sheet2
Make	Assigned
chevy	john; joe
ford	john1
buick	john2;sam;sally

 

[Fluff]

Any reason you want a macro, this can be easily done with formulae.

+Fluff 1.xlsm
	A	B
1	Make	Assigned
2	chevy	John
3	ford	john1
4	buick	john2
5	chevy	joe
6	buick	sam
7	buick	sally
8
Sheet1

+Fluff 1.xlsm
	A	B
1	Make	Assigned
2	chevy	John; joe
3	ford	john1
4	buick	john2; sam; sally
5
Sheet2

Cell Formulas
Range	Formula
A2:A4	A2	=UNIQUE(FILTER(Sheet1!A2:A100,Sheet1!A2:A100<>""))
B2:B4	B2	=TEXTJOIN("; ",,FILTER(Sheet1!$B$2:$B$100,Sheet1!$A$2:$A$100=A2))
Dynamic array formulas.

 

[Danny54]

Thanks for the quick response. I took the formulas and inserted them into the vb code to achieve my new sheet.

Great solution!!

Have a good day and a great weekend

 

[Fluff]

You're welcome & thanks for the feedback.