• remove duplicate consecutive rows using the key PI, m and TT.

    Create transactions when PI, M, TT changes based on the order of date.  When TT changes a new transaction needs to be created.