Transform Table

AQIL-KURJI

Hello all, 

I am trying to transform my data in a certain way but I am not sure what tools would be appropriate for this?

Initial Table: 

Final Table: 

Any idea as to how i can transform this? I tried summarize and it would only get me the first and last filepaths. 

Thanks

Qiu

@AQIL-KURJI 
Something like should help.

1211-AQIL-KURJI.yxmd