How to transpose/crosstable to get the output

[Santhoshraj]

Hi, i have a table like this with millions of rows:

Program id	manager	months +/-	scale	code
NJN	John	2	443	p2efr
AJN	Jim	3	233	p4tew
TRP	Dwight	0	345	t0tre

I need to change the orientation of the table like this:

Program id	NJN	AJN	TRP
manager	John	Jim	Dwight
months +/-	2	3	0
scale	443	233	345
code	p2efr	p4tew	t0tre

Can someone help me with this?

[suwenchuan]

Hi, proposed solution attached

[binuacs]

@Santhoshraj One way of doing this