very easy but i stucked

[Fatih235]

I have a column like this;


aaa
bbb
ccc
ddd

and i want to write it in a row like

aaa,bbb,ccc,ddd

how?

 

[beniez]

Fatih

Highlight the cells you want your values transposed to (eg B11 if your original values are in A1:A3), and enter
=TRANSPOSE($A$1:$A$3)
Then press SHIFT+CTRL+ENTER to put this in as an array function (it develops curly brackets. Et voila.

Ben

 

[Fatih235]

for instance i have 1256 rows in a column,how am i supposed to select in a row for the transpose?is there a more practical way?

 

[scat]

fatih
excel only allows 256 columns so you wouldn't be able to transpose any number of rows greater than that. that limitation aside, another option for transposing is to use paste special>transpose on the edit menu