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
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
Last edited: