View original (French)

Remove alphabetical sorting on a pivot table sheets

Pxl83 Posted messages 1 Status Member -  
Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   -
Hello,

I want to create a pivot table in Sheets with days as column labels.

But Google Sheets sorts my days in alphabetical order, so it shows "Thursday/Monday/Tuesday/Wednesday/Friday/Saturday".

Is it possible for Google to recognize that the cell contains a day of the week so that it sorts them automatically in chronological order?

Thank you for your help

Have a good evening

2 answers

  1.
    JCB40 Posted messages 3058 Registration date   Status Member Last intervention   479
     
    Good evening
    What you can do is put a number in front of each day, for example 1Monday 2Tuesday etc...
    Best regards

    --
    Start by doing what is necessary, then do what is possible, and you will achieve the impossible without realizing it.
    0
    1. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
       
      ... or add a first column with the numbers 1 to 7!
      0
  2. JCB40 Posted messages 3058 Registration date   Status Member Last intervention   479
     
    Hello,
    An example of your file with explanations would be welcome.
    To send a file,
    Make sure there are NO CONFIDENTIAL DATA
    you need to use a file-sharing site like cjoint.com

    Go to this site: https://www.cjoint.com/
    Click on browse,
    Find your file,
    click on open,
    Click on "Create the cjoint link",
    Copy the link,
    Come back here and paste it in a reply...
    Best regards

    --
    Start by doing what is necessary, then do what is possible and you will achieve the impossible without realizing it.
    0