Hi there,
I have two years that have data sequential order, however each year is missing some values. I want to be able to compare the two years and order them in a way that allows me to see which data is missing from each year. The only way to align them is by shifting the cell down, but sometimes you need to shift the data down multiple cells. Is there a way to do this in Alteryx?
See below for the input I currently have and how I would like it to look after I run it through Alteryx.
Current Data I have:
| YEAR 1 | YEAR 2 |
| 1 | 1 |
| 2 | 3 |
| 4 | 4 |
| 5 | 6 |
| 6 | 7 |
| 8 | 10 |
| 9 | 11 |
| 10 | 12 |
| 11 | 14 |
| 13 | 15 |
| 14 | |
| 16 | |
| | |
The Output I want:
| YEAR 1 | YEAR 2 |
| 1 | 1 |
| 2 | |
| | 3 |
| 4 | 4 |
| 5 | |
| 6 | 6 |
| | 7 |
| 8 | |
| 9 | |
10 | 10 |
| 11 | 11 |
| | 12 |
| 13 | |
| 14 | 14 |
| | 15 |
| 16 | |
