As the files are combined, Power Query intelligently matches up the columns across all files based on their headers. This automatic mapping ensures that the data is properly aligned and ready for ...

Image: Susan Harkins/TechRepublic. Load the data into Power Query. Once the data, including the date of birth, is in Power Query, you can add an age column as follows: Select the date of birth column.