Both ways effectively erase the values of any other rows. So manually copying the contents of the rows you need to keep, needs to be done first. 
Both ways effectively erase the values of any other rows. So manually copying the contents of the rows you need to keep, needs to be done first. 