Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Fx to cut long column into two columns Formulas - combined functions
  • Repeated Offset Basic Math
  • Extract Address into table Formulas - combined functions
  • CHOOSE – tree of decisions CHOOSE
  • Min Max vehicle Formulas - combined functions
  • BMI Calculator Basic Math
  • Return 12 values in one number AND
  • Walking Columns ActiveX controls

Rotate table using 1 formula

Posted on February 6, 2012 By ANmar No Comments on Rotate table using 1 formula

Rotating table (Transpose) using functions so that the table is updated once the source table is updated.
Also can be used as automatically rotating tables with variable number of rows and columns

Sheet name can be used inside formula so that you can have multiple tables from different sheets to be rotate it into one sheet

The catch is that you need to know where is that table located and where you want to rotate it.

The best part is that it is a single formula to rotate the entire table including headers, here is the formula

=INDIRECT(ADDRESS(COLUMN()+1,ROW()-6,,,"original table"))

 

 

ADDRESS, COLUMN, Formulas - combined functions, INDIRECT, Lookup and References, ROW, Standard functions

Post navigation

Previous Post: Sort list dynamically (functions)
Next Post: Validation based on another Validation

Related Posts

  • 6174 Kaprekar’s constant Basic Math
  • Cells with additional spaces AND
  • Multiple Dual-Validations COUNTA
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions
  • Custom fiscal year calendar (CFlex) Basic Math
  • Middle name + 1st name Basic Math

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Hello world! Uncategorized
  • 0% interest promotion Basic Math
  • Sort list dynamically (functions) COLUMN
  • Calculate hours between two cells ABS
  • Search across sheets in function ADDRESS
  • Cuts string of list of items Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme