Selecting only cells with text values in CAPS

Is there any way to select only cells with text values written in capital letters? I have attached an example - I need to separate the cells with CAPS because I want to turn the rows into columns (Direccion, Poblacion, Telefono, etc as column headings). I'm not really sure what to do so any help would be much appreciated. What needs to happen is the different Museum details be listed in rows under the headings Direccion (address), Town (Poblacion) etc.