Make Pivot/Unpivot on Table

[IgorGol]

Hi,

I have this table :

Employee Number	Category	Hours	Month
111	Dev	100	1
111	Mainten	190	1
222	Dev	200	1
333	Mainten	300	2
222	POC	100	2

And I want to transform it to this :

Employee Number	Dev	Mainten	POC	Month
111	100	190	0	1
222	200			1
333		3000		2
222			100	2

But I don't sure what I need to write in script ? (cross?)

Thanks!

[Lisa_P]

This is best done in the sheet view when creating a pivot table:

[IgorGol]

Thanks,

But I would like to do the "transform" in script and not in pivot table

cause I want to create some charts on it later

May you help?

Thanks,

Igor

[IgorGol]

Anyone?

[Vegar · Accepted solution]

Hi @IgorGol 

I suggest you look into the GENERIC 

A good read on the method is @hic design blog post The Generic Load .