Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text to columns
I have a worksheet that has the data in rows but I need them in columns. Is
there a way that I can get the data to columns? ( example Rows 1,2,3 need to be Row 1 columns A, B C - Rows 4,5,6 need to be Row 2 columns A,B, C etc) |
#2
|
|||
|
|||
hi,
If i understand you correctly, i think you want to use the paste special - transposed. On the toolbar go EditPasteSpecial. in the dialog box(near the bottom on mine), check Transposed. This will paste data in rows into columns. Good luck FSt1 "jcross" wrote: I have a worksheet that has the data in rows but I need them in columns. Is there a way that I can get the data to columns? ( example Rows 1,2,3 need to be Row 1 columns A, B C - Rows 4,5,6 need to be Row 2 columns A,B, C etc) |
#3
|
|||
|
|||
Thanks
"FSt1" wrote: hi, If i understand you correctly, i think you want to use the paste special - transposed. On the toolbar go EditPasteSpecial. in the dialog box(near the bottom on mine), check Transposed. This will paste data in rows into columns. Good luck FSt1 "jcross" wrote: I have a worksheet that has the data in rows but I need them in columns. Is there a way that I can get the data to columns? ( example Rows 1,2,3 need to be Row 1 columns A, B C - Rows 4,5,6 need to be Row 2 columns A,B, C etc) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Text to Columns in excel for delimited files - allow trimming opt. | New Users to Excel | |||
How do I convert text to columns when there is a carriage return? | Excel Worksheet Functions | |||
Seperating of Text in one cell into two columns | Excel Worksheet Functions | |||
Delete Columns not Containing Certain Text | Excel Worksheet Functions |