Pivot Table

[Puranjaysaprax]

I am looking to pivot this table:

Input Table

ID Number	ID number	Score
a	b	90
a	c	91
a	d	95
b	c	86
b	d	93

Output Table

	b	c	d
a	90	91	95
	c	d
b	86	93

Is there a way to solve this in alteryx?

TIA

[binuacs]

@Puranjaysaprax Are you looking something like this ?

[grazitti_sapna]

Hi @Puranjaysaprax 

As Cross tab will help gathering all the data in the common fields, c and d arent showing up, instead, fitting in their respective fields.

let me know if this was helpful.

[grazitti_sapna]

@Puranjaysaprax, is another approach if you want your output to be specific to what you posted.

Thanks!