In calc Column A has numbers but they are not in order they are not 1, 2, 3, … 51, 52, 53, in fact, the numbers are 1, 2, 3, 4, 1, 2, 3, …46, 47, 48. So how do I get the numbers in sequential order from 1 to 64?
Use the sort function
How? Where is the sort function? I think that will only give me exactly the same set of numbers I already have, in the exact same order they are already in… But how do I do that?
That didn’t work, what it gave me is 1, 1, 2, 2, 3, 3, 4, 4, … 61
What I want is 1, 2, 3, 4, … 61, 62, 63, 64, 65
what it gave me is 1, 1, 2, 2, 3, 3, 4, 4, … 61
You should have mentioned in your question, that you need to eliminate duplicates as well. The result is correct with respect to numbers in sequential order-requirement.
Maybe someone can come up with a solution to what I need.
I gave an example of the data set I have and the format I needed the data to be transformed into, given my illustration I figured words would be superfluous.
As they say, a picture is worth a thousand words.
I was trying to simplify my request.
Maybe someone can come up with a solution to what I need.
You seem to need the impossible, if you have duplicates. Or please tell us how you prefer to correctly and sequentially order 1 and 1.
You used to be able to write the beginning sequence say 1, 2, 3 then click on the first number in the sequence and pull down the box while holding clt or alt or something and the column would renumber itself. But I can’t seem to remember the exact trick to make trhat happen.