Reformatting addresses

Originally Posted by nazim

Hi,
I have a few hundred addresses in excel in the following format

Name Address1 Address2 Address3 Area City Pin

Is it possible for me to change that into

Namee
Address1
Address2
Address3
Area
City-Pin

Please let me know how I can do this. I will be saving countless hrs of typing if this is possible.

Thanks
Nazim

please attach a sample file in zip format to implement formulas.

Originally Posted by nazim

I have attatched a sample file
Thanks
Nazim

upto which column you want data in verticle form? (upto city or Tel1 )

Originally Posted by nazim

till pin
I want it to look like

Name
Address 1
Address 2
Address 3
Area
City-Pin

Or

Name
Address 1
Address 2
Address 3
Area
City
Pin

there was a need for some work around
see the attached file.

Originally Posted by nazim

Hey
that was amazing but I couldnt get the hang of it it was a little complicated for my limited excel abilities. However it got me thinking in the right direction and gave me a couple of ideas to solve my problem. Thanks so much for your help you really saved me a lot of time

Nazim

you're welcome here. thank you for the feedback.

Originally Posted by gmoney10111

How did you do that? I have a similar file that needs the same attention.

Please help.

Hi gmoney

Please read the forum rules. You should not ask your question in others thread. Please start a new thread and give details of your requirement.