[SOLVED} deleting rows and moving data

I have created a spreadsheet with 4820 rows of data (4821 for computational purposes, the last row being blank) with 5 columns. I need help in doing three things.

1. every third row is blank and it needs to be removed (3, 6, 9,...4818, 4821). Once this is accomplished,

2. I need to move the data that is now found in the even rows, column E moved to the above, current odd row, column F. (ie. E2 to F1, E4 to F3, E6 to F5,...E4808 to F4807...,E4820 to F4819 (however it won't go this high). then

3. I need to delete all the current even rows, as the data I need will be in the odd rows.

I am hoping this is not as difficult to do as it is to explain. I am attaching a sample before and a sample after of what I am hoping to achieve.

Many thanks in advance.