Hi all,
I've made a pivot table that should sort the columns by year. However, the years are not appearing in chronological order.
Can anyone suggest the changes I need to make to either the data or the pivot to get this right?
forum.JPG
The data it pulls from only has the years in it - entered as a number - so excel shouldn't be recognising it as a date.
forum2.JPG
I feel like this is a really basic fix, but can't work it out, and am clearly not using the correct key words for google!
Many thanks in advance
Bookmarks