Excel Function to move cell contents at a time. 1

[doldol]

Any excel experts help!

[Cell] A B
1 apple 5
2 banan 0
3 kiwi 8
4 pear 7
5 oreng 9


[red] < MOVE TO -->>

Cell A B C D E
1 apple banan kiwi pear oreng
2 5 0 8 7 9[/red]

Tnx a million.

 

[DaleWatson123321]

Hi doldol,

Steps:

1) Highlight A1:A5, and Copy
2) Move cursor to A7 and use: Edit - Paste Special - Transpose
3) Highlight B1:B5, and Copy
4) Move cursor to A8 and use: Edit - Paste Special - Transpose
5) Delete rows A1:A6

Hope this helps. Please advise as to how you make out.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[bkpchs237]

doldol,

I don't know about a &quot;function&quot; per se, but ignoring the initial column (which could be recreated quite easily) highlight the remaining two columns, the use Edit, Copy, Edit, Paste Special, Transpose. Then recreate the initial column.

Hope this helps.

 

[sfvb]

Dale,

Why not change step 1 to...
1) Highlight A1:B5, and Copy
...and eliminate steps 3 and 4?

 

[doldol]

Dale & bkpchs, sfvb

what a tremendous quick advise......
It is exactly what I,errr.. my user, want to know!
also, sfvb's advise were very helpful.

thank you So Much!!!