Greetings,

I am having a heck of a rearranging some data, and I was hoping that someone might be able to point me in the correct direction. I have a series of individual 'records' similar to this:

Name, John
Location, Las Vegas

Name, Jane
Location, Denver

Name, Joe
Location, Boston


I need to come up with a way to get this data into typical column-style format:
Name, Location
John, Las Vegas
Jane, Denver
Joe, Boston


Has anyone had to do something similar before? Any advice would be tremendously appreciated!!