Formula assist in office 365

Hussein_Mohamed 

I see you're using 365 so this may do what you need:

'Transactions dynamic range
=LET(rng, Sheet1!$A$8:$G$10000, nonblank, COUNTA(Sheet1!$C$8:$C$10000), TAKE(rng, nonblank))
'EGPRef (column b)
=TAKE(DROP(Transactions, , 1), , 1)

=LET(
    FilledEGP, SCAN("", EGPRef, LAMBDA(a, v, IF(v = "", a, v))),
    uEGP, TOCOL(EGPRef, 1),
    DROP(
        REDUCE(
            "",
            uEGP,
            LAMBDA(a, v,
                LET(
                    filtered, FILTER(Transactions, FilledEGP = v),
                    IFERROR(VSTACK(a, TOROW(filtered, 1)), "")
                )
            )
        ),
        1
    )
)