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