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.