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

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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"monika" wrote:
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

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


"Max" wrote:

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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"monika" wrote:
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

Thanks, glad that option appealed to you
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Brad" wrote in message
...
Very nice!!!
--
Wag more, bark less