Summarize data side by side

[Jenina]

Hi All,

Good day!

I want to summarize my data with same content from different input files to easily compare them but for some reason

it can't be summarized that simply, how can I possibly remove the Nulls in the spaces in between. I tried to filter it but some data were lost.

Example is attached. 

Thank you!

[Garrett_Stoker · Accepted solution]

Rather than using a Union, you could use a Join Multiple on the ID fields or by record position if you sort beforehand.

[Jenina]

Thanks! That's also possible.