Functions/VBA for regrouping and merging data

[VoidGenome]

Could anyone please point me in right directions on how to do this with functions/VBA?

The input range is fixed (A3:B10), but the data in both columns are variables.

 

[VoidGenome]

You're welcome, glad to help.

As a matter of interest, did you go with the formula approach, macro or power query?

I chose the VBA one although I don’t really understand the code. TEXTJOIN isn’t available on older version Excel and I figured out everything would be simpler by using VBA instead.

 

[Peter_SSs]

I chose the VBA one although I don’t really understand the code.

OK, thanks - the two codes posted were virtually identical but if you are interested, a more compact version would be:

Sub ClassNames_v2()
  Dim d As Object
  Dim c As Range
  
  Set d = CreateObject("Scripting.Dictionary")
  For Each c In Range("A3", Range("A" & Rows.Count).End(xlUp))
    d(c.Value) = d(c.Value) & ", " & c.Offset(, 1).Value
  Next c
  Range("D3:E3").Resize(d.Count).Value = Application.Transpose(Array(d.Keys, d.Items))
  Range("E3").Resize(d.Count).TextToColumns DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 9), Array(2, 1))
End Sub

 

[alansidman]

Power Query is available on all Excel version starting with 2010. In 2016, it is called Get and Transform and is located on the Data Tab.