If the person asking for the combined data wants any analysis by month, you’ll need to add it. So, let’s do that next: Power Query adds the new column. We’ll add the month to each data set ...

When working with address data, you may encounter situations where you need to merge multiple columns, such as address, town, and postcode, into a single column. Power Query makes this task a breeze.