Filter unique for every blank cells in one column

[MsSunshine2]

Hello,
I’m new to vba and need help. I exhausted my resources trying to figure this out and nothing has worked.

My range can vary every month. I currently have over 700 rows of data.

In column C I have multiple blank & colored filled cells. (Color index=40)
I shared a photo of what I’m trying to accomplish Here’s what I’m trying to accomplish
1. For each blank & colored filled cells in column C, filter unique values within the range starting from the first non-color filled cell above the blank cell to the last non-color filled cell (before the next empty cell. )
2. Enter the unique values in the blank cell concatenated format is comma and space (cell C11 should be 1112, 1113, 1114, 1115)
*** header is excluded from unique values
3. Concatenated values should be in order from top to bottom of unique values
4. Note - column c’s last 2 rows are always blank I need 2nd to the last blank cell filled out with values

Note: scripting dictionary doesn’t work on my workbook and
Thank you in advance for your help.

 

[MsSunshine2]