Moving Data from repetitive rows to repetitive columns

I have data that I copied from a list on the Internet. When I pasted the data, it loaded all of it into column "A". The rows are

"Name"
"Phone Number"
"City"
"Contact"
"Name"
"Phone Number"
"City"
"Contact"
"Name"
"Phone Number"
"City"
"Contact"

and so on.....

I'd like to see those four pieces of information in columns "A"-"D"

Is there a way to have Excel do the work and load rows 1,5,9,13,17,etc... into column "A", rows 2,6,10,14,18, etc... into column "B" and so on.

I really appreciate anyone's help on this.

If your data in column A on Sheet1
Set this formula in cell B2 on Sheet2 - Row 1 is header (copy to the right to the column D)
Copy all down
or search for VBA

Thank You. I couldn't get it to work at first. There was a semicolon instead of a comma after the array. It took me a couple of minutes to find the issue. I plugged it in and now it works.

Thank you so much. I appreciate the help Navic!!