I have some data that was sent to me in a linear fashion with what should
have been the Column headers as row headers. So basically every five rows,
it repeats the same information for the contact - basicallyin column A, First
Name, Last Name, Company, E-mail, and Phone Number, then in repeats every 5
cells. Column B has the information on the contact there.

How can I get the information to rotate, so that I only have one entry for
Column Headers across the top and the data directly underneath?

Thanks in advance,