Populate Multiple Columns from Several Criteria

[JamesRo]

Hi.
I have the following data from SQL database.

Glass_Stock_Orders.xlsx
	A	B	C	D	E	F	G	H	I
1	ORDER_NUMBER	ENTRY_DATE	REQUIRED_DATE	tblPurchaseOrderItems.ITEM_TYPE	tblPurchaseOrderItems.PRODUCT	tblPurchaseOrderItems.QUANTITY	tblPurchaseOrderItems.WIDTH	tblPurchaseOrderItems.HEIGHT	Description
2	000784	16/06/2022 13:33	07/07/2022	Stock	0005	31	3210	2250	5mm FLOAT
3	000837	28/06/2022 08:32	11/07/2022	Stock	0006W	102	3210	2550	6mm OPTIWHITE
4	000538	29/04/2022 07:35	21/07/2022	Stock	0006W	117	4500	3210	6mm OPTIWHITE
5	000539	29/04/2022 07:39	08/09/2022	Stock	0006W	117	4500	3210	6mm OPTIWHITE
6	000838	28/06/2022 08:35	13/10/2022	Stock	0006W	117	4500	3210	6mm OPTIWHITE
7	000840	28/06/2022 08:38	01/12/2022	Stock	0006W	117	4500	3210	6mm OPTIWHITE
8	000784	16/06/2022 13:33	07/07/2022	Stock	0010S	30	3210	2250	10mm FLOAT SATIN
9	000784	16/06/2022 13:33	07/07/2022	Stock	0010W	26	3210	2550	10mm OPTIWHITE
10	000784	16/06/2022 13:33	07/07/2022	Stock	0012	22	3210	2550	12mm FLOAT
11	000784	16/06/2022 13:33	07/07/2022	Stock	0015W	6	3210	2550	15mm OPTIWHITE
12	000843	28/06/2022 09:05	05/07/2022	Stock	0110	11	3210	2250	10mm BRONZE FLOAT
13	000784	16/06/2022 13:33	07/07/2022	Stock	0113	22	3210	2250	10mm GREY FLOAT
14	000837	28/06/2022 08:32	11/07/2022	Stock	1004	34	3210	2250	4mm SILVER
15	000785	16/06/2022 13:47	01/07/2022	Stock	1006AS	27	3210	2250	6mm ANTIQUE SILVER
16	000785	16/06/2022 13:47	01/07/2022	Stock	1006ASB	27	3210	2250	6mm ANTIQUE SILVER BRONZE
17	000841	28/06/2022 08:39	22/07/2022	Stock	1009	17	3210	2550	6mm BRONZE SILVER
18	000841	28/06/2022 08:39	22/07/2022	Stock	1010	17	3210	2550	6mm GREY SILVER
19	000785	16/06/2022 13:47	08/07/2022	Stock	1006AS	27	3210	2250	6mm ANTIQUE SILVER
20	000800	28/06/2022 08:32	14/07/2022	Stock	1004	34	3210	2250	4mm SILVER
21	000801	28/06/2022 08:32	21/07/2022	Stock	1004	34	3210	2250	4mm SILVER
Sheet1

I wish to present the delivery dates as shown in the example below:

Glass_Stock_Orders.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	CODE	WIDTH	HEIGHT		EXPECTED (1st)	QTY		EXPECTED (2nd)	QTY		EXPECTED (3rd)	QTY		EXPECTED (4th)	QTY		EXPECTED (5th)	QTY
2	0005	3210	2250		07 Jul 22	31
3	0005	3210	2550
4	0006W	4500	3210		21 Jul 22	117		08 Sep 22	117		13 Oct 22	117		01 Dec 22	117
5	0006W	3210	2550		11 Jul 22	102
6	0006W	3210	2250
7	0010S	3210	2250		07 Jul 22	30
8	0010W	3210	2550		07 Jul 22	26
9	0012	3210	2550		07 Jul 22	22
10	0015W	3210	2550		07 Jul 22	6
11	0110	3210	2250		05 Jul 22	11
12	0113	3210	2250		07 Jul 22	22
13	1004	3210	2250		11 Jul 22	34		14 Jul 22	34		21 Jul 22	34
14	1006AS	3210	2250		01 Jul 22	27		08 Jul 22	27
15	1006ASB	3210	2250		01 Jul 22	27
16	1009	3210	2550		22 Jul 22	17
17	1010	3210	2550		22 Jul 22	17
18
Sheet2

Hope this makes sense, many thanks.
James.