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