Transpose rows to columns based on Record ID field

[Sudkakani]

Hello Guys,

 I am trying to transpose some data from rows to columns based on ID, but getting incorrect results.

Input data:

Record ID	Name	Value
1	Year	2000
1	Category	Pen
1	Customer Name	Rayn
1	Export	Germany
2	Year	2001
2	Category	Paper
2	Customer Name	John
2	Export	USA

But the expected output should be like this

Record ID	Year	Category	Customer Name	Export
1	2000	Pen	Rayn	Germany
2	2001	Paper	John	USA

Attached input file

Thanks

SudK

[jasperlch · Accepted solution]

Hi @Sudkakani 

I believe what you are looking for is the Cross Tab tool:

[Sudkakani]

yes and Thanks @jasperlch