Forum Discussion

Brysonds's avatar
Brysonds
Icon for Helper III rankHelper 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
Icon for Community Champion rankCommunity 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

 

Anthony007's avatar
Anthony007
Icon for Helper I rankHelper 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.