Excel Array Transpose function
Written By: admin on March 28, 2010
5 Comments
See how to use the Array function TRANSPOSE to transpose a table, switching rows and columns to columns and rows.
In this video, you will see how to create array formulas and see how to use Array Functions.Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell!
Here are some video titles I have:
Excel Statistics 31: Histogram using Data Analysis Add-in
Excel Statistics 08: Install Excel 2007 Data Analysis Add-in
Excel Statistics 84 Confidence Interval Data Analysis Add-in Descriptive Statistics
Excel Statistics 84 Confidence Interval Data Analysis Add-in Descriptive Statistics
Excel Statistics 38: Data Analysis Add-in Rank & Percentile
Do you have a video where you introduce the Data Analysis Tool Pack?
Paste Special Transpose is at ten minute mark.
Do you mean transpose without link?
If so search for and watch this video:
Highline Excel Class 28: More Excel Basics Review
How can I transpose the formulas but retain my relative links? without linking to the original? Basically I have a vertical table that I would like horizontal. Arg, I dont think what I want can be done.