Convert to pivot table

[jocker_boy]

Hello,

I have a big table with data of documentation control (+5000 lines).
Example:

Document (A1)	Version	Site	Owner	Status	Status Date
A001	A	S01	John	Submited	01/11/2022​
A002	A	S02	Vitor	Submited	01/11/2022​
A003	A	S02	Miranda	Submited	01/11/2022​
A001	A	S01	John	Comments	15/11/2022​
A002	A	S02	Vitor	Comments	02/12/2022​
A003	A	S02	Miranda	Approved	02/12/2022​
A001	B	S01	John	Submited	02/01/2023​
A002	B	S02	Vitor	Submited	02/03/2023​

My goal is to obtain this table:

Each row have unique document;
And for each month i have the latest status of that document.
Example:
Document A001 in Novembre was "Submited" in 01/11/2022 and receive "Comments" in 15/11/2022, so the status in November is "Comments".

Document (J1)	set/22 (K1)	out/22 (L1)	nov/22 (M1)	dez/22 (N1)	jan/23 (O1)	fev/23 (P1)	mar/23 (Q1)	abr/23 (R1)
A001			Comments		Submited
A002				Comments			Submited
A003				Approved				​

I can get this table with this formula for cell K2:
{=IFERROR(INDEX($E$2:$E$9;MAX(($A$2:$A$9=$J2)*($F$2:$F$9>K$1)*($F$2:$F$9<L$1)*ROW($E$2:$E$9))-1);"")}

But i would like to have the same result with a pivot table, because with this formula the file becomes to slow because i have more than 5000 lines in my database.
And also, i would like to filter the table with other data, for example: For each owner, for each site. I know i can add this "filter" in the formula, but it isn't fast and practical.

Thanks for all the help.
Gonçalo