Column into Row in EXCEl
 

I need to copy the values there in one column and the same value shoul
be there in the column.

how can i copy the entire column and paste in a row type?



say for example

Code
-------------------

4
2
1
2
3
0
1
2

-------------------

and i need this vaue like this

Code
-------------------

4 2 1 2 3 0 1 2

-------------------


is there any method to do it instead of doing it manually like typin
every number.?


please help me dude !

--
jayender.v
-----------------------------------------------------------------------
jayender.vs's Profile: http://www.excelforum.com/member.php...fo&userid=2864
View this thread: http://www.excelforum.com/showthread.php?threadid=48424

Column into Row in EXCEl
 

Hi,

Assuming your list starts from a1, following should work

Range("a1:h1") = WorksheetFunction.Transpose(Range("a1:a8"))

HTH
Kalpesh

Column into Row in EXCEl
 

jayender.vs Wrote:
I need to copy the values there in one column and the same value should
be there in the column.

how can i copy the entire column and paste in a row type?



say for example

Code:
--------------------

4
2
1
2
3
0
1
2

--------------------

and i need this vaue like this

Code:
--------------------

4 2 1 2 3 0 1 2

--------------------


is there any method to do it instead of doing it manually like
typing every number.?


please help me dude !!


All you need to do is to highlight all the numbers in the column you
want to copy.
Right click and select 'Copy'.
Right click on the first cell in the row where you want to copy the
selected data.
Select 'Paste Special'
In the window that opens up, put a tick in 'Transpose'.
Then 'OK'.
This will copy all the data that you first highlighted in your column
to your choosen row.
By the way, the first cell that you want to paste to, can't be the same
cell that you copied from.


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=484246