I've got a list of names and addresses that I'm trying to organize for a mail merge. These list of names are in a CSV format, I've attached a file as an example. (I had to upload it as a xlsx file...Please change the file extension back to *.csv after you've downloaded it, as the as the forum only allow for excel & picture files). What I am trying to achieve is the final product which looks like the 2nd screenshot. As you can see from the screenshot, there is no consistency where the addresses are. Some are in one cell, some are on 2 cells... to make things worse, the list of names & addresses are in a 3 column format.
What is the best way to achieve this? Is VBA script the most appropriate solution or is there an Excel function that would ado the job?
Original File layout:
Would like the result to look like this: