Transpose Table

[microwin88x]

Hello,

I have the following table:

ID	VALUE	DESCRIPTION	AMOUNT
1	AA	LOCAL	150
1	AA	INTERNATIONAL	100
1	AA	UNITS	12

I need to transpose the table by script in order to have the following:

ID	VALUE	DESCRIPTION	LOCAL	INTERN	WEIGHT
1	AA	LOCAL	150	100	12

Is there any way to do that?

Thank you!!!

[jwjackso]

Check out the Generic Load

[siddheshmane]

You can just add the columns into the pivot table and then Drag the Description column up to transpose the values.