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

edit

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