I saw this same question asked a couple of days ago...

Feb 22nd, 2002, 10:48 AM

But I can't find it know. I remember thinking that I should copy it for future use...hmmmmph

Anyway, can somegive me an exmple of how to move a column of data (A1:A25) into a row (such as B1:Z1) saving me from a C&P nightmare??

Mudface · Feb 22nd, 2002, 10:57 AM

Select the data you want and Copy it. Then right-click in the first cell you want your data to end up in and select Paste Special and Transpose.

Feb 22nd, 2002, 11:27 AM

Worked great, thanks a million!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 22nd, 2002, 10:48 AM	#1
Guest Posts: n/a	But I can't find it know. I remember thinking that I should copy it for future use...hmmmmph Anyway, can somegive me an exmple of how to move a column of data (A1:A25) into a row (such as B1:Z1) saving me from a C&P nightmare??

Feb 22nd, 2002, 10:57 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Select the data you want and Copy it. Then right-click in the first cell you want your data to end up in and select Paste Special and Transpose.

Feb 22nd, 2002, 11:27 AM	#3
Guest Posts: n/a	Worked great, thanks a million!