I have an Excel column with song titles in it. When I do a Pivot table and sort the data by the songs it keeps putting the song titles "Saturday" and "September" at the top with the numbers instead of down in the "S"s. I am assuming it is treating these as numbers instead of text like September is 09 or 9.
What I need is to these date reference names to be in the sort based on the text.
Below is what I am getting
SATURDAY
SEPTEMBER
02 RAIN FROM FALLING 1
03 EASE AWAY THE PAIN 1
04 RUNNING OUT ON ME 1
06 ANYTHING 4 LUV 1
07 GIVE IT TO ME 1
This is what I need.
<colgroup><col></colgroup><tbody>
</tbody>
Thanks in advance
What I need is to these date reference names to be in the sort based on the text.
Below is what I am getting
SATURDAY
SEPTEMBER
02 RAIN FROM FALLING 1
03 EASE AWAY THE PAIN 1
04 RUNNING OUT ON ME 1
06 ANYTHING 4 LUV 1
07 GIVE IT TO ME 1
This is what I need.
SATAN S BREATH 1 |
SATURATE 6 |
SATURDAY |
SATURDAY AT THE MALL ALT 60 |
SATURDAY MORNING |
SATURDAY NIGHT 2 |
SATURDAY NIGHT 3 |
SAVAGE PEAK |
<colgroup><col></colgroup><tbody>
</tbody>
Thanks in advance