Do you have any idea that how to revert a crosstab query back to select query? If no then also need to worry as here in this tutorial we are going discuss about this particular topic only.
So, that you can easily switch back to a "normal" query from a "crosstab query" with just one single click. But before that let's have a short knowledge on difference of crosstab and Normal (Select) query.
And result set of normal (select) query.
In this type of query, months are no longer listed along the top as column headers. They get listed in their own column.
As a Result of this each city needs to be duplicated for each month of sales. So below we will convert the above crosstab query into this select query.