Data analysis

[SouravKayal]

Hi Team,

I wanted to transform data per below but unable to get the right format

Source:

ID Name	Div	Name
abc	xyz	robert
abc	xyz	harry
abc	ggg	lyn
ccc	xyz	Joe
test	xxx	tim

Target

	abc	ccc	test
xyz	robert
xyz	harry
ggg	lyn
xyz		joe
xxx			tim

[alexnajm]

Something like this?

[SouravKayal]

abc	ccc	test
xyz	robert	joe
xyz	harry
ggg	lyn
xyz		joe
xxx			tim

it should be summarisng per division also

[alexnajm]

It is already - I matched your target output with my output!