ChatterBank2 mins ago
Excel question
2 Answers
Yet another Excel question.
Is it possible to transfer a column of data to a row without re-typing?
Answers
1 to 2 of 2
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!
Hopefully this answer's right, sorry about the last one!
1 to 2 of 2
