What "preassigned row number" in what application and version. At best
you will need to "export" to a new sheet or table given the constraints
you impose. It's sort of like saying you want to cross the Atlantic, but
you don't want to take a plane or boat, in which case you will have to
learn how to swim.