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.