data structuring

Hello Everyone,

I have data like

i want to output like

I have designed multiple workflow approaches, but I am not achieving the desired output. Additionally, I aim to update the data dynamically, considering the variations in names and dates.

use sample data :

input.xlsx