How to transpose values from a table and group them by a field?

[#1]

Hello,

This might be too easy to put on the forum but I'm in a bit of a rush. Would be grateful for a helping hand.

I've got a table such as this:

Name	A	B	C
Jack	50	100	150
Jill	25	50	75

I need to transform this table at load time to look like this:

Name	Value	Type
Jack	50	A
Jack	100	B
Jack	150	C
Jill	25	A
Jill	50	B
Jill	75	C

Here's the inline code for the input table:

Table1:

Load * inline [

Name,A,B,C

Jack,50,100,150

Jill,25,50,75

];

Thank you, guys!

Sam.

[Miguel_Angel_Baeyens]

Hi Sam,

This should work:

Table1Final:
CrossTable (Type, Value)
Load * inline [
Name,A,B,C
Jack,50,100,150
Jill,25,50,75
];

The resulting table should have three fields, Name, Type and Value, and values in rows transposed.

Hope that helps.

Miguel