I have a .csv file with an array of text which I need to combine and sort under headings.
Here is an example of one row of the csv file (data is just random to show what I want to do):
Raw CSV format:

A: Hi, my, name, is, John, B: I, am, a, builder, C: I, like, to, skateboard,

I want to group the text based on the identifiers A:, B:, C:,
So the data would look like this after running the macro:
.csv format

A: Hi my name is John, B: I am a builder, C: I like to skateboard,


Any ideas how I could create a macro for this?

Big ask but I am desperate!!

Thanks