how to transpose
oops.
Saw your follow-up post to Ossiemac with the re-configuration you wanted.
Disregard my replies.
Gord
On Sat, 29 Mar 2008 11:37:24 -0700, Gord Dibben <gorddibbATshawDOTca wrote:
Read my reply.
You don't need macros.
Gord Dibben
On Sat, 29 Mar 2008 10:59:00 -0700, help please
wrote:
OssieMac I do not know how to do Macro
"OssieMac" wrote:
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.
|