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.