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
@AQIL-KURJI
Something like should help.