I want to learn how to use macros to change vertical data to horizontal data

Hey folks! So, I've done about two hours of the google-ing... and, I still can't quite figure out how to make this happen. Often, we receive data in vertical columns that we need transferred to horizontal rows so that we can break them down. Here is what I have:
Name
Street Address
City, State Zip
Country
Phone
Fax


I'm hoping to switch this to horizontal, so that Column A is all Name, B is all Street Address, C is all City, State Zip, and so on.... It appears that each school is separated by a blank, so technically if the macro could find the blank, then reset back to Column A, we're in business. I wish I knew how to do these without having to ask for help, but every time I look something up, I just can't make sense of it. Furthermore, when I try to record a macro, it never gets me the desired result.

I greatly appreciate any help anyone can offer. I'm completely overwhelmed, as usual, during the holidays and all, and I hate it. I refuse to be a Grinch...

Alright, I think I got this....Book2.xlsx

Basically, the only variables we have going on are:
-Some have a couple of blanks between one listing, and the next
-Some have a phone/fax, some only have phone

However, like I said, I'd imagine that the macro can find the blank, then know a new listing begins...

Thanks!

SeanEboy,
Try the attached.

You are a magician... Unfortunately, I'm still trying to figure out how exactly it works.

Worked PERFECTLY on the sheet I was playing with.

Now, another one... Except, this one appears to have different data structure as there are blanks within the same record, AND different amounts throughout. Close to being uniform, but not quite. Book5.xlsx


I really appreciate this! I am trying to learn how to work with macros to organize mailing lists for my small business. Excel is so amazing, I want to marry it.

I actually made it happen with another macro I had going. Basically, most of the records had (10) cells, however some only had (9), which the macro didn't like so much. However, luckily only about a dozen had (9) cells, so I was able to find them by letting the macro run until the records skewed, then fixed it from then on.