Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I transform several rows into 1 column in excel?
I am using excel 2003 and I have 500 columns which all need to be put into 1
column. Is there another way besides copy and paste. I've already tried transpose. |
#2
|
|||
|
|||
You could try =A1&b1&c1 ect - this will concatenate all named cells into 1
text string. 500 columns into 1 sounds a weird thing to do but I guess you have your reasons!! If you want spaces between each entry use &" " HTH Sheila "Melanie" wrote: I am using excel 2003 and I have 500 columns which all need to be put into 1 column. Is there another way besides copy and paste. I've already tried transpose. |
#3
|
|||
|
|||
Thanks, I think I worded my question wrong.
What I'm trying to do is change the orientation, so that my column headings become rows. Any ideas? "Sheila D" wrote: You could try =A1&b1&c1 ect - this will concatenate all named cells into 1 text string. 500 columns into 1 sounds a weird thing to do but I guess you have your reasons!! If you want spaces between each entry use &" " HTH Sheila "Melanie" wrote: I am using excel 2003 and I have 500 columns which all need to be put into 1 column. Is there another way besides copy and paste. I've already tried transpose. |
#4
|
|||
|
|||
Melanie wrote:
I am using excel 2003 and I have 500 columns . . . . Really? In Excel? Alan Beban |
#5
|
|||
|
|||
Try Edit|Copy for the data, then for the destination, Edit|Paste
Special... Click the Transpose checkbox. HTH Kostis Vezerides |
#6
|
|||
|
|||
if you have 500 rows and you want to transpose that to columns it will not work as excel only has 256 columns. -- clane ------------------------------------------------------------------------ clane's Profile: http://www.excelforum.com/member.php...o&userid=11865 View this thread: http://www.excelforum.com/showthread...hreadid=475086 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
moving alternating rows to a column with the order staying the sam | Excel Discussion (Misc queries) | |||
find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
Can I set a filter for a merged column across multiple rows and o. | Excel Worksheet Functions |