taking numbers in vertical cells putting them in horizontal ce
Perfect. Thanks!
"JLatham" wrote:
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
|