Excel Array Formula Series #2: TRANSPOSE function

[crnadak87]

You sound a bit like: "Wow, double rainbow..."

Awesome tutorial and thanks a lot!

[ExcelIsFun]

@crnadak87 , you are welcome!

[crnadak87]

you sound a bit like : Wow, double rainbow !

Awesome tutorials btw, thank a lot

[backtoCCCP]

Thank you so much

I spent 2 hours on this

I didn't know about the ctr+shift+enter

[ExcelIsFun]

@backtoCCCP , I am glad that it helped!

[totallyjeffcpa]

Thank You!!! what an awesome formula.

[ExcelIsFun]

@totallyjeffcpa , you are welcome!

[MrArbitrager]

told me what i needed to know (ctrl+shift+enter). Cheers

[ExcelIsFun]

Glad to help!

[GeneralApathyNonFan]

Do you have a video where you introduce the Data Analysis Tool Pack?

[ExcelIsFun]

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

[Tagarashi]

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.

[ExcelIsFun]

Do you mean transpose without link?

If so search for and watch this video:

Highline Excel Class 28: More Excel Basics Review

[ExcelIsFun]

Paste Special Transpose is at ten minute mark.