How to rearrange the order of fields in Excel/spreadsheet?

For example, the order I currently have:
Name:
Phone:
Email:
Address:
Fax:
Website:

But I want:
Name:
Address:
Phone:
Fax:
Email:
Website:

The problem is there are MANY entries in that order, and I CANNOT manually change/drag rows one by one.You can do it with cell references. I am testing this right now, but first please confirm that your data is in rows like this

I have TESTED it. But I await your confirmation as requested above.
Judging by the deafening silence, I expect the OP has worked out how to do this; it is really very obvious, but just in case ANYBODY else is interested, here is how I did it...

Using the first 6 rows which form the set of information about 1 person, in the 2 columns to the right (C and D), I entered formulae to display the contents of columns A and B in the order desired.

(1) Formula view


(2) Values view


Next, I highlighted from C1 to C6 and copied to the clipboard, and PASTED down to the rest of COLUMN C. Then I highlighted D1 to D6, copied them and pasted to the rest of column D.

Then I selected the entire columns C and D, copied them to the clipboard, selected cell A1 of an new worksheet, then "Paste special", values, OK.

(3) Final result