Macro for transposing
Posted by nigel on June 28, 2001 5:00 AM
I am trying to transpose a list of addresses from column A so that each address field reads left to right in columns A through to say I.
The paste special function will only transpose across the entire sheet whereas I need say column A for name, B for street, C for district etc. with each address having its own row.
I have over 1000 addresses
Any ideas how I can do this please?
Posted by Ben O. on June 28, 2001 7:17 AM
I could be misreading the problem, but it sounds like all of your address data is in one column and you want it in multiple columns. If that's the case, select column A and select Text to Columns from the Data menu. That will start a wizard which will guide you through the process of parsing your data.
You'll probably want to choose Delimited as your data type. Hopefully you have commas, tabs, or something else between your Street, City, ZIP, etc. fields. If not, you might have to use spaces as your delimiter and manually clean the data up.
-Ben O.
