I have a Microsoft Access table as show below, Where **Item 1** and **Item 2** are mutually exclusive.
![enter image description here](https://i.stack.imgur.com/CGt8j.png)

I need a query to generate the following result
![enter image description here](https://i.stack.imgur.com/iZtc7.png)

1. Always retrieves all the entries of the table
2. If both **Item 1** and **Item 2** is present (manual editing of database is possible) only values of **Item 2** will be returned in the result.
3. Original table should not be altered

What should I do?