How do I copy cells and remove blank?

Originally Posted by JeteMc

I can see that when you overwrite cell A4 on Tabelle2 it changes the other values, however without knowing what you would expect the other values to be I can't offer much in the way of help. If you change A4 to 20% what do you expect to see in cells B3, B4 and B5? An explanation as to why you would expect to see those values would also be helpful.
The formula is set up so that if there is text in the adjacent cell, in column G, it will copy that text, otherwise it will copy the text from the cell above, in column F. I hope that makes sense.
I don't understand to what "over the corner" is referring?

Everything you did is very good. Thank you.

I use baker's percentage all ingredients are compared to 100% flour.

Maybe the "Data Validation" aka the list where i switch between "alpha" and "beta" should always copy the code into the cells, so they work every time when I want to go back to the original recipe.

The only thing beside THAT is, that I use some ingredients sometimes in more detailed form. For example when I need 50% water but the preparation says half cold water the other half warm water. So I don't need the 50% water in Tabelle3 but 25% warm water and 25% cold water. But I can mark the cell my myself, when I know how.

The file should be now clearer. I put it in: