|re: "can I use this on multiple selections?"|
By that I assume you mean that you have a large number of "address groups" and that you want to place them all into rows instead of a single column.
That is exactly why I said:
4 - Respond with all the things that you didn't tell us in your original post.
The answer is No, you can't use Paste Special...Transpose unless you want to do it manually, group by group.
Excel would have no way of knowing where one set of data (an address group) ends and the next one begins and is incapable of splitting the "paste" into multiple rows.
However, we have options: VBA is always a possiblity but this formula based solution might work for you, as long as you don't mind a few manual steps.
Based on the example you gave us, which is all we have to work with, I'll assume you have groups of 4 lines, A1:A4, then A5:A8, then A9:A12, etc.
If that's the case...
1 - Put this formula in B1 and drag it across to E1:
This should "transpose" your first address group.
2 - Select B1:E4 and press Ctrl-C to Copy it
3 - Select the range starting in B5 and ending in Column E on the last row of your last piece of data.
4 - Press Ctrl-V for Paste
5 - Copy the entire range and do a Copy...Paste Special...Values to get rid of the formulas.
6 - Delete Column A
7 - Sort the range to eliminate the blank rows and bring the transposed data to the top of the sheet.