Match value to correct row after Transpose

[BonusCup]

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

ORIGINAL
ID	name	email	timestamp
123	a1;b2;c3;d4	a1@email.com;b2@email.com;c3@email.com;d4@email.com	a1-a1@email.com-11/8/2023 11:21 AM;c3-c3@email.com-11/8/2023 1:51 PM
456	e1;f2;g3	e1@email.com;f2@email.com;g3@email.com	g3-g3@email.com-11/7/2021 3:30 PM

CURRENT:

CURRENT
ID	email	name	name_timestamp
123	a1@email.com	a1	a1-a1@email.com-11/8/2023 11:21 AM
123	b2@email.com	b2	c3-c3@email.com-11/8/2023 1:51 PM
123	c3@email.com	c3
123	d4@email.com	d4
456	e1@email.com	e1	g3-g3@email.com-11/7/2021 3:30 PM
456	f2@email.com	f2
456	g3@email.com	g3

DESIRED:

DESIRED
ID	email	name	name_timestamp
123	a1@email.com	a1	a1-a1@email.com-11/8/2023 11:21 AM
123	b2@email.com	b2
123	c3@email.com	c3	c3-c3@email.com-11/8/2023 1:51 PM
123	d4@email.com	d4
456	e1@email.com	e1
456	f2@email.com	f2
456	g3@email.com	g3	g3-g3@email.com-11/7/2021 3:30 PM

[TimN · Accepted solution]

I did this.  Not sure it meets your requirement.

[Prometheus · Accepted solution]

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

[BonusCup]

@Prometheus and @TimN thanks.  you both did it the same way.  I definitely over thought it.  I was trying to split to rows all 3 fields at once.  Since it is only 3 fields I can do it this way but if there are a lot more in the future it might get a bit cumbersome.