I am trying to transpose a bunch of data that is repeated ad nauseam down a
column (lets say Column A) and I want to separate the entries so that they
appear listed by column:

Example:

Change this data

Bob Smith Name
3 Smith Street Address
03-9898-1214 Phone

Jane Doe Name
4 Big Avenue Address
03-9898-1215 Phone

Into This Data
Name Address Phone
Bob Smith 3 Smith Street 03-9898-1214
Jane Doe 4 Big Avenue 03-9898-1215