Advanced Transposing?
 

I have a list of contact information in column A, and I want to get that
contact information into columns. How do I do that if every grouping of
contact information does not contain the same amount of rows?

For example column A looks like this
John Doe
123 Main Street
Apt. 4
Nowhere, CA 11111
John Smith
777 Maple Ave
Mary Reynolds

I want it to look like this
A B C D
John Doe 123 Main Street Apt. 4 Nowhere, CA 11111
Joh Smith 777 Maple Ave
Mary Reynolds