I am trying to convert 1 column of data into a row. Is there a simple way to do this?
G Glen in Pen Jul 16, 2008 #1 I am trying to convert 1 column of data into a row. Is there a simple way to do this?
S StumpedAgain Jul 16, 2008 #2 Copy/Cut your row and rightclick the destination. Choose "Paste Special" and check the "Transpose" option. That should do it!
Copy/Cut your row and rightclick the destination. Choose "Paste Special" and check the "Transpose" option. That should do it!
S StumpedAgain Jul 16, 2008 #3 I just tried the Cut/Paste Special... and it's not available. You can only do this using the Copy function. Weird...
I just tried the Cut/Paste Special... and it's not available. You can only do this using the Copy function. Weird...
G Glen in Pen Jul 16, 2008 #4 Sweet. Thanks! StumpedAgain said: Copy/Cut your row and rightclick the destination. Choose "Paste Special" and check the "Transpose" option. That should do it! Click to expand...
Sweet. Thanks! StumpedAgain said: Copy/Cut your row and rightclick the destination. Choose "Paste Special" and check the "Transpose" option. That should do it! Click to expand...
