To retrieve the results in a format that has ‘Currency and Rate’ as the column name and has its corresponding ‘value’ in a row, I would develop a custom wrapper using [Denodo4E](https://community.denodo.com/docs/html/browse/7.0/denodo4e/install_denodo4e/install_denodo4e#installing-denodo4e) extension to achieve this scenario. Also, note that the schema of a view must be static and it cannot be dynamic.
For more information,you could refer to the [Developing Custom Wrappers](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/developing_extensions/developing_custom_wrappers/developing_custom_wrappers#developing-custom-wrappers) section under the Virtual DataPort Developer Guide for more details. You could also find samples for Virtual DataPort Custom Wrapper in the directory ‘<DENODO_HOME>\samples\vdp\customWrappers’ for your reference.
Hope this helps!