Concatenate text, date and time keeping format

Hi everyone, this is my first post on excel forum!

So I have a data sheet with 4 columns: text | text | date | time, that I want to merge separated by comas.
If I try to use a simple concatenate function the date and time get merged as their numbers without proper formatting. So I guessed I would need VBA for this.
I've been trying to get a solution to work there but due to my limited VBA knowledge this has proven to be difficult.

I've attached a sample sheet.

Thanks for your help and time!