Need help! Trying to build a workflow to use crosstab for multiple fields

[darshika_bhatt12345]

Original DataSet

Interview Code	Interview Status	Candidate Name	Candidate Email Address	Position ID	Management Level	Evaluator Name	Evaluator Email Address	Evaluation Completed Timestamp	Candidate Recommendation	Evaluation Status
Pmatrtv-h6zhzf	Complete	Candidate	Candidate@gmail.com	2521178	Senior Analyst	Evaluator 1	evaluator1@gmail.com	2023-03-07 12:53:48 EST	Yes	Completed
Pmatrtv-h6zhzf	Complete	Candidate	Candidate@gmail.com	2521178	Senior Analyst	Evaluator 2	evaluator2@gmail.com	2023-03-08 12:53:48 EST	Yes	Completed
Pmatrtv-h6zhzf	Complete	Candidate	Candidate@gmail.com	2521178	Senior Analyst	Evaluator 3	evaluator3@gmail.com			Evaluation Pending

Desired Result

Interview Code

Interview Status

Candidate Name

Candidate Email Address

Position ID

Management Level

Evaluator 1 Name

Evaluator 1 Email

Evaluator 1 Completed timestamp

Evaluator 1 candidate Recommendation

Evaluator 1 Evaluation Status

Evaluator 2 Name

Evaluator 2 Email

Evaluator 2 Completed timestamp

Evaluator 2 candidate Recommendation

Evaluator 2 Evaluation Status

Evaluator 3 Name

Evaluator 3 Email

Evaluator 3 Completed timestamp

Evaluator 3 candidate Recommendation

Evaluator 3 Evaluation Status

Pmatrtv-h6zhzf

Complete

Candidate

Candidate@gmail.com

2521178

Senior Analyst

Evaluator 1

evaluator1@gmail.com

2023-03-07 12:53:48 EST

Yes

Completed

Evaluator 2

evaluator2@gmail.com

2023-03-08 12:53:48 EST

Yes

Completed

Evaluator 3

evaluator3@gmail.com

Evaluation Pending

[Yoshiro_Fujimori]

Hi @darshika_bhatt12345 ,

Here is one way of doing this.

Field names are not exactly the same as your desired result.

If you do not care much, this workflow should work. (There is a way to fix it, but it takes a few more steps...)

Workflow

You can edit the field name as you like between the Transpose tool and Cross Tab tool.

[darshika_bhatt12345]

Thank you @Yoshiro_Fujimori  This is helpful definately. 

My data set actually has several identical rows so I might need to build a group first maybe.