Dynamic Drop Down List in Dependent Comboboxes

Hello

I have a worksheet "database" with 7 columns, out of which column C & D are GROUP1 & GROUP2. (Please see attached sample sheet)

I am trying to create/pull a report in another sheet "Report" where I want to be able to select GROUP1 & GROUP2 values from 2 comboboxes to display a list under that selection.

I am wondering there is a way I can automatically create a drop-down list in a Combobox1 which will capture & display all the unique values in column C - i.e. GROUP1 and then based on the selection in GROUP1 combobox, only the relevant unique values from column D - i.e. GROUP2 should be displayed in GROUP2 combobox.

Eventhough sample worksheet looks simple, in my real database I have 10-15 unique values in GROUP2 for each unique Value in GROUP1. This list is growing and every week I am adding new GROUP1 - GROUP2 combinations to the list.

Since this part is ever changing, I am struggling to create a List/Range for each unique value in GROUP1, to create a dependant combobox in traditional way. Also, the Unique values in GROUP1 keep getting added.

Is there a way to automate this ?

Thanks
V