How can I cut rows in Calc and have these rows automatically deleted?

In Calc, when I cut a row and insert somewhere else the rows are left blank where I cut from (i hate that) AND the formulas don’t transfer correctly. Formulas in both the row I cut and in rows I haven’t cut get rearranged incorporating other cells.
Libre Office 4, English, Calc

Please what is the question?. Can you explain step by step a single sample, and what is the bad result or wrong formulas?

Do not cut&paste but drag&drop. Mark the row to be moved. Grip the first cell of the row and drag it to the new position and hold down the ALT-key while releasing the mouse button, see help topic “Moving Cells by Drag-and-Drop”.

Thanks! That worked perfectly.