Merge rows together and keep content if indicator is the same

Hi all,

I have a spreadsheet where I have column B that has an "indicator." essentially I have marked all rows that have the same content in column C with a repeating number ..

What I want to do is merge the entire row with vba for all the rows that have the same number (increase by 1 each time) while only merging column C's cells together and keeping all content in column D and column E in the format of "content-in-row-1, content-in-row-2, content-in-row-3, ... content-in-row-n"

Also the rows (after being merged) that are empty will be deleted. We're NOT creating a new sheet or new range for the newly merged cells, just trimming down the current sheet

Heres a picture of what I mean if you have any questions please do not hesitate to ask!

screenshot.JPG

Please help me! I really need to solve this challenge and I appreciate for everyones time!