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.