Excel: Excel/Macros/codes

Hi, I am new to this Forum, and don't have extensive knowledge of Excel. I exported a list from SharePoint to Excel and they got exported as shown on example 1. Is there any codes/macros to convert them to display them as example 2. The lists have hundreds of names, and I have to export the list on monthly basis, so doing it manually would take a lot of time. Any kind of help is highly appreciated. Please let me know if you need more info.

Example 1
Title Name Address
Manager Tom, Harry, Ram NY, VA, NJ
Example 2
Title Name Address
Manager Tom NY
Manager Harry VA
Manager Ram NJ
Thanks, Ralive

This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of July 10, 2014.

For more resources for Microsoft Excel