I have an assignment of data that has been ranked 1 through however many records there are. I want to assign a snaking sequence of A/B and then B/A in order of rank, so it would look something like this:
| Rank | A/B |
| 1 | A |
| 2 | B |
| 3 | B |
| 4 | A |
| 5 | A |
| 6 | B |
| 7 | B |
| 8 | A |
| 9 | A |
| 10 | B |