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.

Power Query’s Columns From Examples feature can do more than transpose values – it can also combine multiple values into a single cell. To illustrate, let’s combine the address elements into ...