MS Excel - Sort pivottable column headings by date
- Joel Lipman
- Excel
- Hits: 5970
This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top.
Why?
The excel report would hit a bug where it couldn't work out that 10 (Wednesday) happened after 8 (Monday).
How?
See the following screenshot and note the dates for Monday, Tuesday, Wednesday, and Thursday: