I have some words in column B. They are sorted by a personal criterion, nothing that Apple Numbers can consider:
At a certain point, I want to organize the information by another criterion. For instance, to make it simple, sort ascending:
Is there a way I can go back to the first picture?
(Here I simplify the case. Of course, I could cmd z, but that is not the point. I am looking for an easy way to save a specific order even after I close the file o even days later)
What I have tried: This is a simplified case. In real live I have several files with thousands of rows in each file. I cannot create a column and give them a number of reference manually. I tried to create a column and generate the order this way:
1- I put 1 in A1
2- Put A1+1 in A2
3- Copy paste the formula in the other columns. Or drag the yellow point, it's the same
4- Create another column and "paste results" (When I sort by the B column the formula column will change. That's why I need that extra step and create a column with only numbers)
This works, but it seems complicated and I need to do it many times. Is there any other way to save the order that is easier, simpler?