I need to copy data from one excel sheet to another.
source sheet
1
2
3
4
5
6
the data is to be copied in the following format
1 2
3 4
5 6
the copy paste method does not allow this because the regions are different.
Can this be done in any other way.