Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Middle name + 1st name Basic Math
  • Validation based on another Validation COUNTA
  • Calculate hours between two cells ABS
  • Skills Grid Conditional Formatting
  • BMI Calculator Basic Math
  • iframe in Excel (XLiFrame) ADDRESS
  • Progress bar in pure functions CHAR
  • CamelCase to Camel Case CHAR

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

  • Zipcode-State search Formulas - combined functions
  • Schedule column Basic Math
  • Standard math to calculate Aspect Ratio Basic Math
  • Multiple-Validations (connected to each other) Data Validation
  • CamelCase to Camel Case CHAR
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS

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
  • Jan8 date format AND
  • DayName Date and Time
  • CamelCase to Camel Case CHAR
  • Text-to-Columns, dynamically using formulas IFERROR
  • Limited Ceiling Basic Math
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Looplist – Repeating months using formulas Basic Math
  • Search across sheets in function ADDRESS

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme