Cross tab - The most basic question in the world

[DKMI]

I am not finding cross tab intuitive, and wonder if someone can help.

I have a dataset like this:

Field name	Result
Name	Peter
Age	56
shoesize	10
Name	Susan
Age	15
shoesize	9
Name	James
shoesize	10
Name	Petra
Age	56
shoesize	8

I want it to look like this:

Name	Age	shoe size
Peter	56	10
Susan	15
James	75	10
Petra	56	8

No matter what combination I select in the cross tab tool, I cant seem to do this :(

[ShankerV]

Hi @DKMI 

To achieve the below, you need 2 steps.

Step 1: MultiRow formula tool.

Create New Field: S. No

IF [Field name] = "Name"
THEN [Row-1:S No]+1
ELSE [Row-1:S No]
ENDIF

Step 2: Crosstab tool.

Group data by these values: S.No 

Change Column Headers: Field name

Values for New Columns: Result

Many thanks

Shanker V

[DataNath]

Hey @DKMI, you need a couple of additional steps here. First, I have just filtered out the empty rows, assigned an index to each person every time we see 'Name' and then used this to Group By in the Cross-Tab. Hope this helps!

[flying008]

Hi, @DKMI 

FYI.

[grazitti_sapna]

Hi @DKMI 
I Have made workflow for your use case .Hope it works for you.
Thanks