Finding last occurrence cell of a multiple partial text in a row and retrieving contents adjacent to that cell

[shyna23]

Finding last occurrence cell of a mu

Item	Action date	ACTION TYPE PERFORMED BY	Action date	ACTION TYPE PERFORMED BY	Action date	ACTION TYPE PERFORMED BY	Action date	ACTION TYPE PERFORMED BY
45685	2-Jun-2019	Submitted (Jansson [Requestor])	4-Jun-2019	Submitted (Jansson[Requestor])	3-JUN-2019	Submitted (Monica [Admin]) <colgroup><col width="64"></colgroup><tbody> </tbody>	6-JUN-2019	Submitted (Mahesh [Admin]) <colgroup><col width="64"></colgroup><tbody> </tbody>
25698	8-JUN-2019	Submitted (Peter [Requestor])	10-JUN-2019	Submitted (Nagraj [Admin])

<tbody>
</tbody>

ltiple partial text and retrieving contents adjacent to that cell . Below
table shows how my data looks.

In the result file I need to display as below. If you notice the 1 row had submitted [Requestor] status twice and I need the date from 2nd occurrence of action. I tried using INDEX and MATCH but was not successful Can anyone help me with a formulae to retrieve the date beside the occurrence of a text.

Item	Submitted ([Requestor])	Submitted ([Admin])
45685	4-Jun-2019	3-JUN-2019
25698	8-JUN-2019	10-JUN-2019

<tbody>
</tbody>