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.