Make comma delimited list from column data using search criteria

[rarexcel]

If I have the following data in two columns, I need VBA code that creates a new table that finds the data associated with A,B, or C and then lists it as comma delimited text --

It's kind of like a sumif in Excel except that instead of adding numerical values, I need to create a list of text.

Column One
A
A
A
B
B
C

Column Two
Text 1
Text 2
Text 3
Text 4
Text 5
Text 6

The result would look as follows:

A Text1, Text2, Text3
B Text4, Text5
C Text6

Any help you can give would be appreciated.

 

[DonkeyOte]

If the data is sorted as implied do you really need VBA ?

A basic helper route might suffice...

Excel Workbook
	A	B	C	D	E
1	Hdr	Hdr	Hdr	Results	Text
2	A	Text 1	,Text 1	A	Text 1,Text 2,Text 3
3	A	Text 2	,Text 1,Text 2	B	Text 4,Text 5
4	A	Text 3	,Text 1,Text 2,Text 3	C	Text 6
5	B	Text 4	,Text 4
6	B	Text 5	,Text 4,Text 5
7	C	Text 6	,Text 6
Sheet2

 

[rarexcel]

Thank you so much

This is perfect AND I don't have to code in VBA.

I can't believe I've never encountered the REPT function before...