Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Row to Column
I have a row with 94 entries.
I would like this data converted to a column instead. Is there an easy way to accomplish this? Thank you. |
#2
|
|||
|
|||
Brian
Copy the row. Assume row 1 Select A2 and Paste SpecialTransposeOKEsc. Gord Dibben Excel MVP On Mon, 6 Dec 2004 16:45:03 -0800, "Brian" wrote: I have a row with 94 entries. I would like this data converted to a column instead. Is there an easy way to accomplish this? Thank you. |
#3
|
|||
|
|||
Thank you Gord, worked like a charm.
"Gord Dibben" wrote: Brian Copy the row. Assume row 1 Select A2 and Paste SpecialTransposeOKEsc. Gord Dibben Excel MVP On Mon, 6 Dec 2004 16:45:03 -0800, "Brian" wrote: I have a row with 94 entries. I would like this data converted to a column instead. Is there an easy way to accomplish this? Thank you. |
#4
|
|||
|
|||
This works great, as long as you don't have more than 256 entries.
"Gord Dibben" wrote: Brian Copy the row. Assume row 1 Select A2 and Paste SpecialTransposeOKEsc. Gord Dibben Excel MVP On Mon, 6 Dec 2004 16:45:03 -0800, "Brian" wrote: I have a row with 94 entries. I would like this data converted to a column instead. Is there an easy way to accomplish this? Thank you. |
#5
|
|||
|
|||
bass
OP stated "94 entries" so will have no problem, but thanks for the added caveat. Gord On Tue, 7 Dec 2004 09:53:02 -0800, "crazybass2" wrote: This works great, as long as you don't have more than 256 entries. "Gord Dibben" wrote: Brian Copy the row. Assume row 1 Select A2 and Paste SpecialTransposeOKEsc. Gord Dibben Excel MVP On Mon, 6 Dec 2004 16:45:03 -0800, "Brian" wrote: I have a row with 94 entries. I would like this data converted to a column instead. Is there an easy way to accomplish this? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide column but show chart | Charts and Charting in Excel | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |