Matrix Transform

Matrix Transform is a tool specially designed for the “transformation” (or manipulation) of rectangular “blocks” of data.

Those who are familiar with graphics software should have already been familiar with the “transform” of graphics, in which you can flip or rotate graphic items easily using a toolbox. There was also where the ideas of Matrix Transform came from.

“Why tables typed in Excel cannot be rotated or flipped as easily as in graphics packages?” I believe spreadsheet users with considerable curiosity should have thought of this question while using Excel. (This is in fact a dream function of mine for many years!)

Now, Excel Power Expander provides you with an advanced solution to the above question. This solution is also one which has been fully adapted to the spreadsheet environment. It does more than simple rotations and flips. Basically, you can do the following matrix transformations :

  1. Rotate (90°, 180°, 270°)
  2. Calculations -
    • Cofactor matrix
    • Adjoint matrix
    • Inverse matrix
    • Transpose
    • Self multiplication (to the n-th power)
    • Multiplication by a constant
    • Division by a constant
  3. Flip (horizontal, vertical

It must be emphasized that rotations and flips are NOT LIMITED TO CONSTANTS. Excel Power Expander will intelligently take all the formulas, formats, and even notes into consideration when performing the transformations, and allows you to decide which one(s) of those you want to include in the transformation. This makes Matrix Transform more versatile to use.

To “transform” a range, just select the range to be transformed, and run Matrix Transform. The range selected MUST be a single rectangular range. Whether it should be a “square” range (with equal number of rows and columns) depends on the transformation function you want to perform.

The 3-step transformation wizard -

Matrix Transform is a 3-step wizard, which guides you through the transformation/manipulation of (rectangular) blocks of cells.

Step 1 - In this first step, you decide the type of transformation you want to perform. (Rotate, Calculate, or Flip)
Step 2 - You will see the Step 2 dialog box only if you chose “Rotate” or “Flip” in Step 1. In this step, you decide whether to rotate/flip the values/formulas/format/notes in the selected range.
Step 3 - In this final step, you’re prompted for the addresses of the “source range” and the “target range”.
“ Source Range” is the range which contains the block of cells you want to transform.
“ Target Range” is the location the transformation output will be placed.

For the ease of use, you don’t necessarily have to define a target range with exact dimensions. You just need to decide the top-left cell and Excel Power Expander will correct the output dimensions for you.