Need to fully understand your question. Does your data look like this all in
one column:-

Name
Street
City
State
Zip
Name
Street
City
State
Zip
and then repeated that way down the column? If it does, then I have a macro
that will rearrange it with column headers so that the names address etc are
set out across the worksheet like this:-

Name Street City State Zip

However, depending on the number of lines per name and address etc, it might
require a little editing. If you want it, then please post a sample of your
data. (Not real data that will identify anyone; use ficticuous names and
addresses.)

Also, if you want it, do you require any instructions to copy the macro in
and run it?


--
Regards,

OssieMac


"help please" wrote:

how do I change the lay out of an excel spread sheet, I have name address
city state and zip in column A all the way down, in lines of 3 about 900
addressess. I want to change them to the top of the page across, with
name-street-city-state-zip. I cant seem to get it to do what I want, any help
would be greatful.