If you data is always 4 rows of address then a blank row and then again 4
rows of next address and so on do the following:-

copy this address range from Cell F6 downwards

then on cell A2 type for company name
=INDEX($F$1:$F$5000,(ROW()*5)-4)

On cell B2 type for address1
=INDEX($F$1:$F$5000,(ROW()*5)-3)

On cell C2 for City,state
=INDEX($F$1:$F$5000,(ROW()*5)-2)

And finally on D2 for phone
=INDEX($F$1:$F$5000,(ROW()*5)-1)

and copy these 4 formulas all the way down.

This will give you your desired address list in columns that you can then
copy-- paste special-- values

to de-link them from the formulas and you could then easily sort


"steve_g" wrote in
message ...

I have a list of addresses I want to sort. It was exported from a
website, so it came into Excel this way:

Company Name1
Address1
City, State, Zip1
Phone1

Company Name2
Address2
City, State, Zip2
Phone2

And so on...

My goal is to get this list into colums where column A is Name, column
B is Address, column C is CityStateZip and ColumnD is Phone. This way
I can do a mail merge, or import it into Access.

I hope my example makes sense. Thanks for your help.

Steve


--
steve_g
------------------------------------------------------------------------
steve_g's Profile:
http://www.excelforum.com/member.php...o&userid=24410
View this thread: http://www.excelforum.com/showthread...hreadid=380116