How to transpose the data?

Follow

AP

• April 10, 2017 08:32

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)

 

1

• 

  Alan Mark

  • April 10, 2017 14:37

  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

  Comment actions Permalink

Please sign in to leave a comment.