Extract features from an excel file and merge with polygon Some of the rows will have a ‘Y’ against a ward or some wards that the informati

I have a large excel file with multiple columns with different attribute information, some of these columns have information about the local authority wards, for example;

Some of the rows will have a ‘Y’ against a ward or some wards that the information relates to.

For each row I want to match fields that have a ‘Y’ and merge with the ward polygon file creating a polygon of the matched wards, so for the above example there with a polygon file with 4 wards.

Any suggestions on the best way to approach this?

Thank you in advance.