Copy A1:C1, then right-click on A2 Paste special Transpose OK.
Then delete row 1.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Willc" wrote:
Hi everyone:

if i have some number at column and i want to switch all the numbers to
vertical in one times,how can i do this.

For example : i have 1 at A1 cell, 2 at Number at B1 cell and 3 at C1
cell, how can i switch/rotate all my data to A1/A2 and A3 cell?