Does anyone know how I can copy and paste formulas from specific columns to other rows by row count. For example:

Let say I have 16 rows of formulas.

G2 has a formula, as does H2, G3, H3,G4, H4,G5, H5 Etc.

Now, let’s say the next set of data only has 12 rows of formulas, how do I copy the formulas to those 12 rows only?

And the next set of data may have 15 rows of data.

I know I can sort and cluster by row count (all the 16s together, all the 15s together, all the 12s together).

Forever grateful

Frank