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!!