conditional transpose

  1. G

    Transpose Formula when Certain Criteria are met

    Hi All, Apologies if this has been asked before but I have searched and only found similar requests, nothing solving my exact issue. I have some weekly KPI data which gets collated each month into charts. The data is entered each week and totaled using sum formulas onto a sheet. I have a chart...
  2. E

    Formula to Transpose Diagonals using OFFSET

    Hi All, I have the following sample data. Excel WorkbookBCDEFGHIJKL3Quarter0123Sep-01Dec-01Mar-02Jun-024Sep-0124384878242225255Dec-012237453837366Mar-02253648457Jun-022578Sheet1 Using the table on the left, I have manually created the desired table on the right. It basically transposes the...

Some videos you may like

This Week's Hot Topics