Insert a new worksheet into the book. Go to the first sheet and select all
of the cells and use Edit -- Copy (or [Ctrl]+[C]) to copy them, go to the
second sheet and use Edit -- Paste Special with the "Transpose" box checked.
See if that doesn't do the trick for you.


"jhawk22" wrote:

I'm looking for the formula that will take numbers in vertical cells putting
them in horizontal cells. I'm copying from a worksheet that has numbers
listed in columns and need to put them into cells that are in rows.

Thanks