Thanks for the suggestions, the CONCATENATE function works but the amount of rows i have is over 1000 (see the attached excel document above)

So is there a way to CONCATENATE all of them automatically without needing to put row name e.g. (A1, A2, A3, A4) manually in the formula?

The other one, is there a easy way to remove the subtitle time e.g. 00:00:04 --> 00:00:08 from the output as well?

Cheers.