Paste Format again

[vaughn9]

I have two columns of data
eg.
Colum A Column b
John 200
Paul 300

I want them to appear horizontally when I copy and paste

eg.

Column A ColunmB ColumnC Column D
John 200 Paul 300

but when I copy and transpose it appears like this

John Paul
200 300

I need to be able to paste each cell across so it appeas like mey example

Help

 

[Hasit]

The transpose function is working correctly. It is taking the data in the left hand column and putting it as row data.

From what you have described, the initial setup of:

[tt]John 200[/tt]
[tt]Paul 300[/tt]

tells me that you only want to move "Paul 300" to the next available and adjacent cells on the right. Is it not possible just to cut and paste "Paul 300" and paste them in column C? That would give you the result you are looking for.

 

[vaughn9]

Yes I could cut and paste, but I have a great deal of data that I am working on in order to move quickly I wanted to be able to be more efficient that cutting and pasting.

I was wondering if Excel would allow me to paste side by side from column format to row format

 

[Hasit]

Yes it would, but the way I suggest, not through any standard option (such as TRANSPOSE). Have you considered code to allow you to do what you need. I am not a coder, so wouldn't know where to start, but you could look at code yourself, by recording a macro and having a look at that.