Excel Transpose Question

Yes, same data for each person. Tried to cut and paste an example, didn't work so well. Basically cell A1 would have last name, B1 would have first name, C1 would have phone number, D1 is blank, E1 starts over with new person, E1 last name, F1 First name, G1 phone number. My goal is to have all of column A be Last name, B be first name, C be phone number. Row 1 would be person one, row 2 would be person two, row three would be person three.

Schwartz Chris 333.3333 Swenson Ryan 123.4556 Sorenson Brian 333.4566

Schwartz Chris 333.3333
Swenson Ryan 123.4556
Sorenson Brian 333.4566

Again, thank you very much for your help.