If you have created a Pivot Table to display your data, but when you try to sort your data by column it doesn't appear to work as you expected, it may be that a standard table is more suitable for your use case. This video explains the difference between these two formats.