I'm using a pivot table to rearrange the data in a spreadsheet. When I do this, the info in the date field changes. I'm assuming I'm missing something simple in what I'm doing, but I am clueless as to what it may be. Insight from someone would be very much appreciated.
I'm attaching a spreadsheet with an example. In the original data, all events are in 2015. The second worksheet shows how I created the pivot table. I copied and pasted as values, the info from the pivot table into the third worksheet and then formatted the dates as a custom format.
Many thanks.
Bookmarks