grouping 2 data cells within a range

Hello Xelers,

I need a formula/function that fills column D to which group the data of column B ( group to be found in
column G) AND the data of coumn C (group to be found in column H)
The data are refreshed daily. That is why I need the formula/function itself
The first 2 lines D2 and D3 showing you of how I need the data to be presentd (no coloring)

Thank you very much for your kind help

Thomas