Finding first, second, third matches

[surkdidat]

I need help where I have an identifier I am using in INDEX-MATCH, but this may appear more than once. The IDs wont be consecutive rows, and culd be anywhere over the space of 10000+ roes

Data

ID	Start Date	End Date
12345	01/01/23	08/01/23
12345	12/12/23	14/12/23
13579	14/01/23	31/01/23
14702	02/03/23	08/02/23
14702	08/08/23	09/09/23
12345	01/01/24	04/03/24

Output

ID	Start Date1	End Date1	Start Date2	End Date2	Start Date3	End Date3
12345	01/01/23	08/01/23	12/12/23	14/12/23	01/01/24	04/03/24
13579	14/01/23	31/01/23
14702	02/03/23	08/02/23	08/08/23	09/09/23

 

[JamesCanale]

MrExcelPlayground22.xlsx
	A	B	C	D	E	F	G
1	ID	Start Date	End Date
2	12345	1/1/2023	1/8/2023
3	12345	12/12/2023	12/14/2023
4	13579	1/14/2023	1/31/2023
5	14702	3/2/2023	2/8/2023
6	14702	8/8/2023	9/9/2023
7	12345	1/1/2024	3/4/2024
8
9
10	ID	Start Date 1	End Date 1	Start Date 2	End Date 2	Start Date 3	End Date 3
11	12345	1/1/2023	1/8/2023	12/12/2023	12/14/2023	1/1/2024	3/4/2024
12	13579	1/14/2023	1/31/2023
13	14702	3/2/2023	2/8/2023	8/8/2023	9/9/2023
Sheet5

Cell Formulas
Range	Formula
A11:A13	A11	=UNIQUE(A2:A7)
B11:G11,B13:E13,B12:C12	B11	=TOROW(TAKE(FILTER(B2:C7,A2:A7=A11),3),0)
Dynamic array formulas.

I don't sort this here, you may want some sort for the first 3 - maybe the data entry order is always right, so no sort is needed.

 

[ExceLoki]

try this
-------------------

multiple posts solutions-v3.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	ID	Start Date	End Date		ID	Start Date 1	End Date 1	Start Date 2	End Date 2	Start Date 3	End Date 3
2	12345	1/1/2023	8/1/2023		12345	1/1/2023	8/1/2023	1/1/2024	3/4/2024	12/12/2023	12/14/2023
3	13579	1/14/2023	1/31/2023		13579	1/14/2023	1/31/2023
4	14702	2/3/2023	2/8/2023		14702	2/3/2023	2/8/2023	8/8/2023	9/9/2023
5	14702	8/8/2023	9/9/2023
6	12345	1/1/2024	3/4/2024
7	12345	12/12/2023	12/14/2023
1,2,3 matches

Cell Formulas
Range	Formula
E2:E4	E2	=UNIQUE(A2:A7)
F2:K2,F4:I4,F3:G3	F2	=TOROW(FILTER($B$2:$C$7,E2=$A$2:$A$7))
Dynamic array formulas.

 

[surkdidat]

Superb - thanks guys! Works perfectly!

 

[ExceLoki]

happy to help