How to Concatenate/Union Excel Files with Different Columns?

How to Concatenate/Union Excel Files with Different Columns?

Example:

  • File 1: Name, Address, Gender, Age, Zipcode

  • File 2: Name, Address, Gender, Age, Zipcode, City

  • File 3: Name, Address, Gender, Age, Zipcode

  • File 4: Name, Address, Gender, Age, Zipcode