Help with Transposing / Pivoting Table

[Brysonds]

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?

[Sean · Accepted solution]

@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]

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.

[Brysonds]

This worked perfectly!!