Move data from ascending rows to columns

Good day! I have a data base of 'contacts' that includes "name" "title", "location", "address 1", "address 2", "phone" and "email" all listed in column "A" line by line. each "contact" is separated by one line.

I want to move each of the data points in each "contact" to be displayed in columns across the page. I wan to do so in an automated way not one by one.

Any assistance is appreciated.

if I understand your request

if I understand your request correctly it should be a case of copying the data, and in a new sheet paste special ? Transpose

Regards
Mark