microsoft excel - Take data from one row and convert to 4 rows and repeat every four rows

I would like to go from here:

To here:

If there are other ways to do this please let me know. I've tried the offset and index features to no avail. The problem is when I try to autofill to the end of the sheet. I don't know how to get the formula to keep going in sets of four.