transposing postal addresses

[monika]

Hi There,

I have a list of postal addresses listed in column A - is there a way to
transpose all of them at once to be in rows, under each other?
ie
company address address address postcode phone

etc?

thanks

 

[Max]

Perhaps this tinker ..
Assuming data starts in A2 down, in standard groups of 6 lines each,
with a blank line in between groups
In B2: =OFFSET($A$1,ROWS($1:1)*7-7+COLUMNS($A:A),)
Copy B2 across to G2, fill down as far as required

 

[Brad]

Very nice!!!
--
Wag more, bark less

Perhaps this tinker ..
Assuming data starts in A2 down, in standard groups of 6 lines each,
with a blank line in between groups
In B2: =OFFSET($A$1,ROWS($1:1)*7-7+COLUMNS($A:A),)
Copy B2 across to G2, fill down as far as required

 

[Max]

Thanks, glad that option appealed to you