Donate SIGN UP

Excel question

Avatar Image
Chapel | 13:45 Wed 07th Sep 2005 | Technology
2 Answers

Yet another Excel question.

Is it possible to transfer a column of data to a row without re-typing? 

Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by Chapel. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Yes, select the column of data and choose Copy. Place the cursor where you want the new row to start, right-click and choose Paste Special. Check the "Transpose" box at the bottom, then choose OK. Delete the original data (Paste Special doesn't work when you Cut).

Hopefully this answer's right, sorry about the last one!
Question Author

As always, great stuff Ralph.

1 to 2 of 2rss feed

Do you know the answer?

Excel question

Answer Question >>