Mega Code Archive
Categories
/
MSOfficeExcel 2007 Tutorial
/
Lookup Reference Functions
TRANSPOSE(array) returns the transpose of an array
Input the formula: =TRANSPOSE($A$2:$C$2). And Select A7, A8, A9. Press Shift+Control+Enter to get the result.