Vertical Field Names and Values to Horizontal

[PWaicus]

Hi, all:  Sample data and desired output is in the attached workflow.  I have a dataset with two columns - one contains repeating three field names and the other their respective values (9 lines total, making up 3 actual records.  Here is how they are laid out in the data:

Record      Field Name      Value

1                Account            1

2                Code                100

3                Name               ABC

4                Account            2

5                Code                200

6                Name               DEF

7                Account            3

8                Code                300

9                Name               XYZ

I want to transform them so there are three records total with the three field names and their respective values along the horizontal, as shown below.  The Crosstab tool does not seem to be working the way I thought to accomplish this.  Any help is much appreciated!

Record      Account     Code     Name

1                1                100        ABC

2                2                200        DEF

3                3                300        XYZ

[Thableaus · Accepted solution]

Hi @PWaicus 

Here's a solution:

- Use Multi-Row formula if your "FieldName" field follows an order like "Account, field, field, Account"...

IF [Field Name] = 'Account' THEN [Value]
ELSE [Row-1:RecordID] ENDIF

This way you create the RecordID

- Use Cross-Tab Tool grouping by RecordID field.

WF attached.

CHeers,

[PWaicus]

Ahhh - perfect.  Thanks much, @Thableaus!