Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Insert Blank rows into table using functions CHAR
  • Fixed length ID Formulas - combined functions
  • Highlight dates dynamically AND
  • Jan8 date format AND
  • Fx to cut long column into two columns Formulas - combined functions
  • GoLast to jump to last cell in a column CELL
  • Skills Grid Conditional Formatting
  • WorksheetName and WorksheetsNo UDFs Lookup and References

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

  • CamelCase to Camel Case CHAR
  • Limited Ceiling Basic Math
  • Min Max vehicle Formulas - combined functions
  • Workdays – Across months DATE
  • Hyperlink usage and HyperlinkOf UDF CELL
  • Validation based on another Validation COUNTA

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
  • Extract Address into table Formulas - combined functions
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
  • Always get 1st name (or last) Formulas - combined functions
  • OFFSET+MATCH Formulas - combined functions
  • 0% interest promotion Basic Math
  • BMI Calculator Basic Math
  • Fixed length ID Formulas - combined functions
  • SimpleANBox Basic Math

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme