How to transpose the data?

2 followers
1
Avatar

Hi There,

  I am wondering if there is any way to perform matrix transform operation in a sheet?

I have some mathematical data which can benefit from matrix transpose operations (https://en.wikipedia.org/wiki/Transformation_matrix)

 

AP

1 comment

  • Avatar
    Alan Mark

    Hi AP,

    Please see our documentation on GROUPSELECT:

    Syntax

    GROUPSELECT(<any>;<any>;<any>)

    Description

    Create columns with selected values using a key constant from a specified grouped column in the workbook. 

    Select a column from a worksheet and write in a constant from that column.  Next, select the value column for which to compare the constant from the original column. 

    0
Please sign in to leave a comment.