Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vertical column to horizantal data
I have been copying and pasting data to and from a column in Excel and
various other utilities like notepad. I need to have the vertical data/cells (1,000+) in a horizontal format. Is there a quick easy way to do this? TIA |
#2
|
|||
|
|||
In other words:
How can I change one long column into one long row? "NewsGuy" wrote in message ... I have been copying and pasting data to and from a column in Excel and various other utilities like notepad. I need to have the vertical data/cells (1,000+) in a horizontal format. Is there a quick easy way to do this? TIA |
#3
|
|||
|
|||
NewsGuy,
You can use Excel's TRANSPOSE function to convert rows to columns or columns to rows. Assume you have the numbers 1, 2, and 2 in cells A1, A2, and A3. Select the range A1:A3. Go to the Standard Toolbar and select Edit - Copy. Put your curser in cell C1. Go to the Standard Toolbar and select Edit - Paste Special. In the Paste Special dialog box, add a check mark to the Transpose option. Hit the OK button to complete the change. ---- Regards, John Mansfield http://www.pdbook.com "NewsGuy" wrote: In other words: How can I change one long column into one long row? "NewsGuy" wrote in message ... I have been copying and pasting data to and from a column in Excel and various other utilities like notepad. I need to have the vertical data/cells (1,000+) in a horizontal format. Is there a quick easy way to do this? TIA |
#4
|
|||
|
|||
Just note that if the column is longer than 256 rows it can't be transposed
so if the OP's set of data is 1000+ cells it won't work (at least not if he wants to do it in one fell swoop) -- Regards, Peo Sjoblom "John Mansfield" wrote in message ... NewsGuy, You can use Excel's TRANSPOSE function to convert rows to columns or columns to rows. Assume you have the numbers 1, 2, and 2 in cells A1, A2, and A3. Select the range A1:A3. Go to the Standard Toolbar and select Edit - Copy. Put your curser in cell C1. Go to the Standard Toolbar and select Edit - Paste Special. In the Paste Special dialog box, add a check mark to the Transpose option. Hit the OK button to complete the change. ---- Regards, John Mansfield http://www.pdbook.com "NewsGuy" wrote: In other words: How can I change one long column into one long row? "NewsGuy" wrote in message ... I have been copying and pasting data to and from a column in Excel and various other utilities like notepad. I need to have the vertical data/cells (1,000+) in a horizontal format. Is there a quick easy way to do this? TIA |
#5
|
|||
|
|||
Big time thanks John!
"John Mansfield" wrote in message ... NewsGuy, You can use Excel's TRANSPOSE function to convert rows to columns or columns to rows. Assume you have the numbers 1, 2, and 2 in cells A1, A2, and A3. Select the range A1:A3. Go to the Standard Toolbar and select Edit - Copy. Put your curser in cell C1. Go to the Standard Toolbar and select Edit - Paste Special. In the Paste Special dialog box, add a check mark to the Transpose option. Hit the OK button to complete the change. ---- Regards, John Mansfield http://www.pdbook.com "NewsGuy" wrote: In other words: How can I change one long column into one long row? "NewsGuy" wrote in message ... I have been copying and pasting data to and from a column in Excel and various other utilities like notepad. I need to have the vertical data/cells (1,000+) in a horizontal format. Is there a quick easy way to do this? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent Hidden Column data from being copied/pasted? | Excel Discussion (Misc queries) | |||
How to convert columns of data to one column of text | Excel Worksheet Functions | |||
merge data from multiple columns to single column | Excel Worksheet Functions | |||
Matching data in one column to another | Excel Worksheet Functions | |||
filling a forumla down a column from data across a row | Excel Worksheet Functions |