Split 2 Rows with 8 Columns into 4 Rows with 4 Columns?

[polyocho]

I have a spreadsheet with data populated with the fields from A1 - D1 (4 columns) that are the same as fields populated from E1 - H1 (4 columns). This repeats on line 2 and 3 such that A2-D2 and E2-H2 also contain equivalent fields. How can this be converted in Excel 2013 so that I can eliminate duplicated fields on the same line and have a spreadsheet that has twice as many rows with half as many columns:

An example is in this table:

First name	Last name	Address	Street	First name	Last name	Address	Street
Bob	Pine	123	Apple st.	Robert	Oak	234	Pear st
Abe	Maple	234	Orange st	Ted	Birch	345	Tomato st

How can this be converted to:

First name	Last name	Address	Street
Bob	Pine	123	Apple st.
Robert	Oak	234	Pear st
Abe	Maple	234	Orange st
Ted	Birch	345	Tomato st

This row is actually much longer and there are many rows.

If there were only one row something this might work:
Assuming your data is in row 1, A2 could have =INDEX($1:$1,(ROW()-1)*4+COLUMN()-1). Drag across to column D and down as necessary.

But I am not sure how to do this when there are multiple rows involved.

[Special-K]

If the order is not important can't you just cut and paste columns E-H at the bottom of columns A-D?

[polyocho]

Can't because it is actually much longer. I edited the post (see above).

[Speshul]

Unless there are over 524,288 rows in each of the two columns, cut/paste would work and only take a few seconds.

1. Select the First Name on the second data set (E2 if your data starts in A1)
2. Hold Control + Shift
3. Press the End Key. All data in the second column should be selected
4. Ctrl + X
5. Click cell A2
6. Press the End key
7. Press the Down Arrow twice
8. Press Control + V

Done!

[polyocho]

The actual situation is like this: Data spans from A-FR in rows 1-30. ABCDEFGABCDEFG... This pattern repeats ~20 times per row. The above example is an oversimplification. Copying and pasting in this case will take about 1200 operations. So I am really looking to learn if there is a faster way to do it.