If you don’t want to turn the option off, but don’t always want to create calculated columns as you work in a table, you can stop calculated columns from being created automatically.
If you are used to use VBA, you also can run the below VBA to merge every other row.1.
Hold ALT button and press F11 on the keyboard to open a Microsoft Visual Basic for Application window.2.
However, editing the formula in that column for that row would ordinarily change the calculation for the entire column because, by default, formulas always replicate throughout the entire column in a table.
To make a “one-off” formula in a table, enter the desired formula in the cell of interest and press Enter.
Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.