Macro to search multiple values corresponding to another one and concatenate them in a different column

[scruffy89]

Hello everyone! I am new to excel so I kinda need some help.
I have 3 columns A , b and C which look something like this: (only there are a lot more values)

A B C
Band1 Song1 Band1
Band1 Song2 Band2
Band2 Song3 Band3
Band1 Song4
Band3 Song5
Band2 Song6
Band3 Song7

I need another column D with all the songs coresponding to a band; I want the sheet to look like this:

A B C D
Band1 Song1 Band1 Song1 Song2 song4
Band1 Song2 Band2 Song3 Song6
Band2 Song3 Band3 Song5 Song7
Band1 Song4
Band3 Song5
Band2 Song6
Band3 Song7

Is it possible to do this with a macro? Manual work would take a few days

 

[DocAElstein]

Thanks Alan!.....

. Yous welcome

.....'ll look at the formulas too, but I think I'll stick with the macro.

.. I tend to agree, those CSE Formulas are giving me a few headaches just now... You need a high level of confidence and experience with them which I do not have . They appear sometimes to be a lot more difficult to “get into” than a VBA code,. – I think you can try and debug better with VBA should anything go wrong.
. But possibly it is just down to experience,

Alan