I am trying to take an exported report and reformat it so that it can be imported into another system. I cleaned up the spreadsheet as much as possible, but column B has the address and phone number in mutliple rows under each name (the name in Column A) This is an adress list that has approximately 4800 contacts in it. I need each address to be in one row, multiple columns. I am struggling to find a macro that will workk because the number of rows in between each entry is inconsistent. Can anyone help?? I attached a small sample of what the spreadsheet looks like. Thanks!

Attached Files

Address List.xls (29.5 KB, 20 views)