Creating a macro in Excel

[mmg]

I have an Excel spreadsheet with over a thousand names and addresses listed in column A. Ex. Cell A1 is the name, A2 Address line 1, Cell A3 Address line2, etc. There is one blank row between each address. I need all the addresses to go across the columns. Ex. The first address would be -A1 is name, B1 is Address line1, C1 is Address line2, etc. Then the next address would go into A2,B2,C2...and so on

Is there a macro that can be created that will make this work? I don't know much about creating macros. I've been having some problems because the addresses are not consistent. Some of them have three address lines while others may only have one. The only thing consistent is there is one blank row before the next address starts

 

[Bernard Liengme]

I recommend you send this question to the newsgroup
microsoft.public.excel.programming
Best Wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address

I have an Excel spreadsheet with over a thousand names and addresses

listed in column A. Ex. Cell A1 is the name, A2 Address line 1, Cell A3
Address line2, etc. There is one blank row between each address. I need
all the addresses to go across the columns. Ex. The first address would
be -A1 is name, B1 is Address line1, C1 is Address line2, etc. Then the next
address would go into A2,B2,C2...and so on.

Is there a macro that can be created that will make this work? I don't

know much about creating macros. I've been having some problems because the
addresses are not consistent. Some of them have three address lines while
others may only have one. The only thing consistent is there is one blank
row before the next address starts.