also @ TechSpot: Initial findings suggest Foxconn plant conditions are above average
Welcome to the TechSpot OpenBoards. Please read the FAQ if you have any questions. Sign up or Login to participate.

Go Back   TechSpot OpenBoards > Software > Software Apps

Download Now:

Excel Question

Thread Tools Search this Thread
  #1  
Old 03-15-2005
Newcomer, in training
 
Member since: Mar 2005, 1 posts
Excel Question

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  
Old 03-15-2005
TechSpot Evangelist
 
Location: has left the building
Member since: Aug 2003, 8,165 posts
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
Closed Thread

Similar Topics
Topic Replies Forum
MS Excel Question 0 Software Apps
I need help with Excel! Please! 3 Software Apps
Excel, help please!!!!!! 4 Software Apps
noob excel question 3 Software Apps
excel vba 1 Software Apps

Thread Tools Search this Thread
Search this Thread:

Advanced Search
All times are GMT -4. The time now is 10:47 PM.