Select the data, do edit =Copy, select another location, do Edit=Paste
Special and select the Transpose box at the bottom of the dialog.

--
Regards,
Tom Ogilvy

"yaoming " wrote in message
...
well imagine a sheet is like this all filled:


1234
4567
8910


So, i want a macro with data that is already on the sheet to switch
spots, or positions to this.

148
259
361
470

Is this possible. But for now, i just want to find out a way to copy
and paste the cells. Formulas are not important.


---
Message posted from http://www.ExcelForum.com/