How do i sort my data to produce a sorted paired row + sorted position outcome?
Desired Outcome:
Row | Position |
---|---|
R1 | A01 |
R2 | A01 |
R1 | A02 |
R2 | A02 |
R1 | A03 |
R2 | A03 |
R3 | A01 |
R4 | A01 |
R3 | A02 |
R4 | A02 |
R3 | A03 |
R4 | A03 |
To do this, you need to create a sorting group. You can use this formula:
=ROUNDUP(INT(RIGHT(A5,LEN(A5)-1))/2,0)
Like this:
You can then use the sort dialog configured like this:
If you want to change it so that you are sorting three of the values in the Row column at a time, you would change the denominator in the formula to 3, and so on.