Can anybody help. I need to no "if" and "how" to move rows in excel across to columns without having to copy and paste them individually.

For example.

I have 500 sets of 3 rows in column A. I need A1 to remain in A1. A2 to become B1 and A3 to become C1 and A4 to become D1, A5 to become A2, A6 to become B2, A7 to become C2 and A8 to become D2 and so on. Is there an easier an quicker way of doing this other than individually scrolling down and copying and pasting each one.