say i have data in cells a1- a10, b1 - b10, c1 - c10

if i delete cell a8, i want cells a9 and a10 to move up one, cells b1 and b2 become cells cell a10 and b1 respectively, cells c1 and c2 become cells b10 and c1 respectively, etc

can this be done and if so how? hopefully not too difficult thank you