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.

 

I would like to the table to look like this:

 

The goal of the transformation is to take the 'Division' column which contains duplicates (because of multiple people belonging to that Division) and instead have a unique list. Then for each additional 'Authorized User' beyond 1, a new column would be created as needed (Authorized User2, Authorized User3, etc.).

 

Is this possible?

 

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

     

3 Replies

  • 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

     

    • 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.