How to copy data in row to column

Would like to know how to copy data (MS Excel) in row to column?

you shouyld be able to do this:

1. select the data on your row
2. click on copy
3. go to your destination
4. right click and select "Paste Special"
5. make sure you select "Transpose". that's the function that allows what you requested.

hope this helps.

Adi

Thanks Adi...

By the way, I try to use transpose worksheet function but cannot work. The following are the function that i type in a cell

=transpose($A$1:$C$1)

into cell A3 to A5, and all give me value of cell A1 instead of A1 to C1. So, would like to know what i have done wrong?

I don't think you can put that code in a cell. when i tryed it, it came up with the #VALUE message.

the best way to automate this is to have a button working out the function for you like this:

Range("$A$1:$C$1").Select
Selection.Copy
Range("A2").Select
Selection.PasteSpecial Paste:=xlAll, Operation:=xlNone, SkipBlanks:=False _
, Transpose:=True

hope this helps

To comment on what you did wrong when using transpose function:

1. As this is an array function, ie it returns value in multiple cells, you have to highlight the range in which the values are to be pasted, e.g. you have to select cells A3 to A5

2. Then go ahead and enter =TRANSPOSE(A1:C1) but after that you must press ENTER+SHIFT+CTRL, not just ENTER (remember, this is an array function).

But the way Adi suggested is easier and faster: you don't have to count the number of cells you have to select before entering the function.