Perhaps try a conditional. For example if you are using categorised symbology, under Column you could put
if("Genetic250" IS NULL,"Genetic1MA","Genetic250")
Then you will get symbols for all values of Genetic250, and where that is null then you will have symbols for all values of Genetic1MA (only where Genetic250 is null - this distinction should be made clear to anyone using the data).
You can also use this to individually set values for your symbology, for example
if("Genetic250" IS NULL,"Genetic1MA","Genetic250") = 'ridged till' will display features #10690 - #10693 in your data.
if("Genetic250" IS NULL,"Genetic1MA","Genetic250") = 'rogen moraine' will display features #10688 - #10689 even though #10690 - #10693 also have the same Genetic1MA value.
If that is confusing you could use
"Genetic250" = 'ridged till' and
"Genetic250" IS NULL AND "Genetic1MA" = 'rogen moraine' for the above two situations respectively, but it's easier to make mistakes...
How are you implementing the colour symbology? As far as I am aware, using data-defined overrides for colour will not show up on the legend (How to style a vector layer in QGIS using hexadecimal color code stored in attribute?)