To add wards to your data from another set that has both the address and ward listed, you can use Power Query in Excel or Power BI.
1. Import both data sets into Power Query. To do this, go to the "Data" tab in Excel or the "Home" tab in Power BI and select "Get Data" > "From File" > "From Workbook" to import the first set. Repeat the process to import the second set into a separate query.
2. Merge the two queries. To do this, go to the "Home" tab in Power Query and select "Merge Queries" > "Merge Queries as New". In the "Merge" dialog box, select the first query as the left table and the second query as the right table. Then, select the common column (the address) in both queries and click "OK".
3. Expand the merged query. In the new merged query that appears, select the column with the ward information and click "Expand" in the "Column" tab in Power Query. In the "Expand" dialog box, uncheck all columns except for the ward column and click "OK".
4. Remove any unnecessary columns. If the merged query has any columns that you don't need, you can select them and click "Remove Columns" in the "Transform" tab in Power Query.
5. Load the query into your workbook or report. Once you have finished editing the merged query, you can click "Close & Load" in the "Home" tab in Power Query to load it into your workbook or report.
This will add the ward information to your original data set based on the address.
Let me know if you have any questions.
