Changing data layout

[Shadoxic]

Ok, so I just got help with something extremely similiar, and have honestly tried to work this out (it took me half an hour to work out how to run a macro) but I'm now at a loss.
I have to transform this:
_A_________________B________________C_______________D____________________E_________________F
1 Name __________________Address 1 ___________________Address 2 _______________Address 3 _____________________Address 4 ____________________Address 5
2
3 Mr John Smith___________12, cottage road
4 _______________________Kelvindale
5 _______________________-Glasgow
6 ________________________Scotland
7 _______________________-_G61 1234
8
9 Miss Swanson__________13, Glendarule Sq.
10 _______________________Coatbridge
11 _______________________Glasgow
12 _______________________G61 1231


into this:
A B C D E F
1 Name ______________Address 1 _____________Address 2 ___________Address 3 _______________Address 4 _____________Address 5
2
3 Mr John Smith _____12, cottage road _________Kelvindale ___________Glasgow ________________Scotland ______________G61 1234
4
5 Miss Swanson _____13, Glendarule Sq. _______Coatbridge ____________Glasgow ______________________________________G61 1231

I tried Thanks again!

 

[doofusboy]

Look into Copy - Paste Special - Transpose

Something like this in code:

    Range("A1:A6").Copy
    Range("A15").PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=True

 

[Shadoxic]

Look into Copy - Paste Special - Transpose

Something like this in code:

    Range("A1:A6").Copy
    Range("A15").PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=True

I forgot to mention the spreadsheet goes 15 thousand rows down on the theme in OP :P

 

[Shadoxic]

Can anybody help with this? I've been continuing trying to work it out, it seems to me like it has to be done in two stages, one moving the address under, and the second the macro code that I previously used. However, I know nothing :/

 

[Shadoxic]

Giving this a last bump before I go home. Anybody able to help me ?