Changing rows to columns without copy' transpose'?

[questionforyou]

Excel doesn't allow me to cut' paste' special transpose'. Anyway to leave out the copy paste scenario and just switch the information as is?

 

[Claymationator]

Welcome to the board!

Use the TRANSPOSE Function...see the example below:

Sample Data
Test Date Test Data
3/10/2011 55
3/11/2011 73
3/12/2011 59
3/13/2011 61
3/14/2011 98
3/15/2011 97
3/16/2011 89
3/17/2011 73
3/18/2011 97
3/19/2011 89

Transposed using the TRANSPOSE formula...make sure to enter as an array.

Excel Workbook
	D	E	F	G	H	I	J	K	L	M	N
2	Test Date	3/10/2011	3/11/2011	3/12/2011	3/13/2011	3/14/2011	3/15/2011	3/16/2011	3/17/2011	3/18/2011	3/19/2011
3	Test Data	55	73	59	61	98	97	89	73	97	89
Sheet3

Excel 2010

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

Hope that helps.

 

[questionforyou]

Wow thanks for the quick reply appreciate it and worked no problem

 

[Claymationator]

Glad to help, and glad that it worked for you.