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