How to expand a formula into a column with merged cells in excel?

Question

excel

There is a big table. One column consists of individual cells and merged. I cannot expand the formula written in the top cell to the entire column, because different cell heights. There is a union and 2 cells each and 10 each. How can you manage to manage and still stretch?

Answer 1

Use merged cells in calculation tables...
And if, in essence, if you need beautiful tables with merged cells at the output, then make a separate sheet with a flat table and records of the DB type (previously it was written how it should look like) where and make all the calculations.
And in the final beautiful plate with, God forgive me, merged cells, display only the result.

Answer 2

By selecting multiple cells (with ctrl) and then Paste Special -> Formulas, this can be done.