transpose question

[jvoortman]

I have a list that has, company (cell A1) street (cell B1)
city (cell C1) Province (cell D1) etc. I want it to list
them straight down row A. for example:
company (cell A1)
street (cell A2)
city (cell A3)
Province (cell A4)
etc

 

[Dan E]

Copy (or cut) the range (A11)
Put you cursor in A1
Paste Special and check off transpose

Dan E

 

[jvoortman]

your idea works if I only need to transpose onerow, but
there are 100+ rows, so what it tries to do is instead of
putting directly below one another in column A, it puts
the first company and it's information down columnA, the
second company and it's info go down column B, the third
compnay and it's info go down column C and etc. I would
like them to all do below one another down column A. A
soace betwee each company (and it's info)would be handy
but not crucial

 

[Alan Beban]

Is there a uniform number of columns for the addresses?

Alan Beban