grouping data to remove null values

[mehdibenayed]

i want to transform it like that :

what can i do ?

[LRuCelver]

What does the data look like in the source(s)?

Is it a table like the first image, or are it multiple files?

[mehdibenayed]

there are multiple files 

[LRuCelver]

Can you share samples/examples for the structure of the files so we can try to contruct the data structure you want?

It looks like the files have been concatenated when they should have been joined using common key fields.

[dataexplorer]

I agree with @LRuCelver . Can you try joining the files