|The example in your post no longer makes sense. The data in the second line of your output doesn't match the data in the second address group. |
Assuming that that is just a typo, here's a non-Macro way of getting what (I think) you want.
Assuming your data starts in A1...
In G1 and G2 enter 1 and 6:
Grab the fill handle and fill down until the last value equals the first Row of your last address group.
Each value in Column G should be the first Row number of each address group.
In B1 enter this formula:
=OFFSET(INDIRECT("$A"&$G1), COLUMN()-2, 0)
Drag this over to E1 then drag A1:E1 down as far as you need to to get all of your groups transposed.
Then Copy...Edit...PasteSpecial...Values to replace the formulas with the text.
As you drag the formula down, the INDIRECT function will create a reference to A1, then A6, then A11, etc.
As you drag the formula across, the COLUMN()-2 will create the rows argument (1, 2, 3, 4) for the OFFSET function. The cols argument will always be 0.