Match value to correct row after Transpose

Question

Hi,

I have some data coming in with concatenated fields.  I've transposed, split to rows, used Tile and cross tabbed to get the 'Current' result below.  The issue I'm having is in the 'name_timestamp' field.  I'm trying to match that field to the correct row for the same name and email.  TIA

ORIGINALIDnameemailtimestamp123a1;b2;c3;d4a1@email.com;b2@email.com;c3@email.com;d4@email.coma1-a1@email.com-11/8/2023 11:21 AM;c3-c3@email.com-11/8/2023 1:51 PM456e1;f2;g3e1@email.com;f2@email.com;g3@email.comg3-g3@email.com-11/7/2021 3:30 PM

CURRENT:

CURRENTIDemailnamename_timestamp123a1@email.coma1a1-a1@email.com-11/8/2023 11:21 AM123b2@email.comb2c3-c3@email.com-11/8/2023 1:51 PM123c3@email.comc3 123d4@email.comd4 456e1@email.come1g3-g3@email.com-11/7/2021 3:30 PM456f2@email.comf2 456g3@email.comg3

DESIRED:

DESIREDIDemailnamename_timestamp123a1@email.coma1a1-a1@email.com-11/8/2023 11:21 AM123b2@email.comb2 123c3@email.comc3c3-c3@email.com-11/8/2023 1:51 PM123d4@email.comd4 456e1@email.come1 456f2@email.comf2 456g3@email.comg3g3-g3@email.com-11/7/2021 3:30 PM

TimN · Accepted Answer

I did this.  Not sure it meets your requirement.

Prometheus · Accepted Answer

@BonusCup There's probably an easier way to do this, but here's my solution.