Learn Excel Episode 835: Transposing Formulas

Posted in Companies, Podcasts on September 02, 2008

Tim asked a question about writing a formula that he could copy across a row which would automatically grab successive values from down a column. (Basically doing a Transpose that is always updating). In Episode 835, I will show you my formula method and also discuss Kathy's easier suggestion that will work in some cases.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Formulas, Paste Special