I have a Google Spreadsheet that is published to the web and embedded in a website. This spreadsheet has data about hotel rooms, such as hotel name, number of rooms, date in and out, etc.
I would like to know if there is a way to allow the user to sort the data by any of the columns (sort by hotel name OR number of stars OR minimum nights, etc.).
I found an app that will pull the data and allow the user to filter it, hiding the data that doesn't match their query. I need to achieve something similar but with sorting, not filtering.