Forum Discussion

Brysonds's avatar
Brysonds
Helper III
9 years ago
Solved

Help with Transposing / Pivoting Table

Hi! I would like to transform a table. Is it possible based on the information provided below?   Here is my current table - notice there are two unique users that belong to the 'North' Division. ...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    Brysonds

    1) Add Column tab - Add Index From Zero

    2) Transform Tab - Standard dropdown - Modulo - enter 2 in the dialog

    3) select Index Column - Pivot Column - Values Column - select Authorized User - Advanced Options - Do Not Aggregate

    4) Rename the 2 new columns

     

Sean's avatar
Sean
Community Champion
9 years ago

Brysonds

1) Add Column tab - Add Index From Zero

2) Transform Tab - Standard dropdown - Modulo - enter 2 in the dialog

3) select Index Column - Pivot Column - Values Column - select Authorized User - Advanced Options - Do Not Aggregate

4) Rename the 2 new columns

 

  • Brysonds's avatar
    Brysonds
    Helper III
    9 years ago

    This worked perfectly!!

  • Anthony007's avatar
    Anthony007
    Helper I
    7 years ago

    Hi Sean.

     

    Аctually this model works only if there is no more than two values ​​for one parameter. If there are three or more values, then the appropriate number of values ​​should be set in Modulo. And this is not convenient if the data is updated.