Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Standard math to calculate Aspect Ratio Basic Math
  • Repeated Offset Basic Math
  • Hello world! Uncategorized
  • Search across sheets in function ADDRESS
  • Limited Ceiling Basic Math
  • When Excel tells you to go get some life Excel User tips
  • FORMULATEXT to show formulas FORMULATEXT
  • Text-to-Columns, dynamically using formulas IFERROR

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

  • Week number to Month number DATE
  • Min Max vehicle Formulas - combined functions
  • 6174 Kaprekar’s constant Basic Math
  • DayName Date and Time
  • iframe in Excel (XLiFrame) ADDRESS
  • Limited Ceiling Basic Math

Leave a Reply Cancel reply

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

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

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 (83)
    • 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 (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • 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 (6)
      • Average (1)
      • 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
  • Validation based on another Validation COUNTA
  • Stale values (Scratched functions) Excel User tips
  • Paste Special Percentage Excel User tips
  • Extract Address into table Formulas - combined functions
  • Middle name + 1st name Basic Math
  • Sum of divide – Array formula Array formula
  • CTRL+Y a mini macro Excel User tips
  • Expenses calendar, FaCal Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme