By eHow Computers Editor
Rate: (6 Ratings)
Transposing data in Microsoft Excel instructs the program to return a vertical range of cells as a horizontal range or vice versa. “Transpose” must be entered as an array formula, which is a formula that calculates multiple values and returns a single result. You will use “transpose” to change the vertical and horizontal orientation of an array on a worksheet. Here are some steps to transpose a data array in Microsoft Excel.