Data In A Spreadsheet That Need To Be Re Sorted

I have data in a spreadsheet that need to be re sorted. Here is the data:

Name Address Address Address Phone
XYZ 123 Main NA WI, 12345 123-123-1234
ABC 123 South NA AZ, 1111 456-456-4567

is there a way (i.e marco) that can reorder this info to look like this?


XYZ
123 Main
NA
WA, 12345
123-123-1234

ABC
123 South
NA
AZ, 1111
456-45-4567