Macro to transpose one column into multiple rows over MANY lines of data?

[mtc]

Sorry if this is so specific.
I have a list of contact info; it is 9905 lines of text I need to convert into a spreadsheet. The info was in PDF form, I imported to Excel and used conditional formatting to highlight the phone numbers, fax, email and web addresses; so it would be easier to be sure I was getting the info to the correct place.
I need a macro to help me transpose the info into a new sheet in the workbook. Each contact entry is about 10 lines then it skips a line and the next entry is about 10 lines. I need a marco to transpose the 10 lines or 11 lines across instead of down; but I need it to run all 9905 lines of data at once.
Everything I have found in other forums are limited to only a few lines.
Can anyone help me? PLEASE?! I am desperate! Oh I am using Excel 2010
Thanks!