display multiple values of same field in one row of Pivot table, when common relation exists

[#1]

Hi all

I really didn't know how to input a more meaningful title....

I have a datatable which looks somewhat like

Common	SKU	Price	colour	weight
A	Aaa	1	blue	10
A	Bbb	4	yellow	40
A	Ccc	5	red	60
B	Ddd	6	green	304
C	Eee	2	magenta	40
C	Fff	4	brown	68
D	Ggg	7	black	70

the Common field groups SKUs which are linked together.

in a Pivot table, I would like to show such info as below:

SKU	Price	colour	weight	Alternative1	colour alt1	Alternative2	colour alt2
Aaa	1	blue	10	Bbb	yellow	Ccc	red
Bbb	4	yellow	40	Aaa	blue	Ccc	red
Ddd	6	green	304	-	-	-	-
Eee	2	magenta	40	Fff	brown	-	-
Ggg	7	black	70	-	-	-	-

is this possible at all?

thanks!

[Gysbert_Wassenaar]

See attached qvw.

[#3]

it really seems IT, thanks!

will try to re-produce it on a sample dataset and implement it in real dataset. reload is scheduled tomorrow, so expect me to come back by then.

Alvast bedankt!