Hello,
I have a csv file attached here.
Attached is a screenshot of the custom sorting I am applying to the columns A-C.
The issue is that I am expecting column C to contain patterns of 0-10-20-30-40-50-0-10-20... and repeating.
In practice this isn't what is happening.
To be clear, I want the file to be first sorted by column A from 1 to 30, and only then by columns B and C, where each number in column B (for example 5) has 6 values (0-50):
1,5,0
1,5,10
1,5,20
1,5,30
1,5,40
1,5,50
1,6,0
1,6,10
...
1,6,50
...
...
1,12,40
1,12,50
1,13,0
...
...
Any clues as to my mistake?
Thank you
Bookmarks