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!

book1.xlsx

Garrett_Stoker

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