So, take the value of the rightmost/last [TL] value for each [Name]? We can use the Transpose Tool and then the Summarize Tool to resolve this, like so:
When we Transpose the dataset, the leftmost column is transposed first, and the rightmost column comes last. So when we use the Summarize Tool afterward to fetch the last value for each [Name], we'll get the rightmost value.