Matrix array

[#1]

I have a next table

Table Purchase orders

Product,Ordernr, Qty, ETA

A,12345,10,20140615

A,12390,25,20140819

A,12455,50,20140720

B,12359,15,20140930

C,12300,20,20140509

C,12345,50,20140615

There are three Orders  for Product A

There is one Order for Product B

There are two orders for Product C

Must be displayed in a array which is sorted on ETA

The o

Table Stock

Product, AFS

A,55

B,0

C,15

Tabel Product

Product Description,Usage

A,ProductA,40

B,ProductB,5

C,ProductC,10

We want this to have in a following matrix

Product	Description	AFS	PO Array1 Qty	PO# Array1	PO Array1 Date	POT	PO Array2 QTY	PO# Array2	PO Array2 Date	POT	`PO Array3 Qty	PO Array3 Date
A	ProductA	55	10	12345	20140615	25	50	12455	20140720	20	25	20140819
B	ProductB	0	15	12359	20140930	0
C	ProductC	15	20	12300	20140509	20		12345	20140615

Can some please help me how to solve this.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[#3]

Hoi Gysbert,

Dit werkt !

Bedankt

Arthur