Excel Question

By FRANK123
Mar 15, 2005
Topic Status:
Not open for further replies.
  1. I Would Like To Convert An Excel Row Of Data Which Runs Across To An Excel Column Which Runs Down Is There A Way I Can Do This??
  2. RealBlackStuff

    RealBlackStuff Newcomer, in training Posts: 8,165

    First off, stop using capitals at the beginning of each word, makes for very awkward reading.

    TRANSPOSE
    See Also

    Returns a vertical range of cells as a horizontal range, or vice versa. TRANSPOSE must be entered as an array formula in a range that has the same number of rows and columns, respectively, as array has columns and rows. Use TRANSPOSE to shift the vertical and horizontal orientation of an array on a worksheet. For example, some functions, such as LINEST, return horizontal arrays. LINEST returns a horizontal array of the slope and Y-intercept for a line. The following formula returns a vertical array of the slope and Y-intercept from LINEST:

    TRANSPOSE(LINEST(Yvalues,Xvalues))
    Syntax

    TRANSPOSE(array)

    Array is an array or range of cells on a worksheet that you want to transpose. The transpose of an array is created by using the first row of the array as the first column of the new array, the second row of the array as the second column of the new array, and so on.

    Example

    Suppose A1:C1 contain 1, 2, 3, respectively. When the following formula is entered as an array into cells A3:A5:

    TRANSPOSE($A$1:$C$1) equals the same respective values in A3:A5
Topic Status:
Not open for further replies.


Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.