Matching Columns and Aligning Data by Including Blank Cells

[lavender_alias]

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

[Raj]

Find the Sol Attached.

[Brankl]

Raj's solution looks right, but I think there's an easier answer.

• Separate out Year 1 and Year 2 into separate tables using two instances of the select tool
• Join the data together and union together all 3 join outputs
• Create a third column to take the longer string of the first two to make that third column the one you sort by

[Qiu]

@lavender_alias 
Similar with the idea of @Brankl but I am not sure it is now simpler or not. 😁

[lavender_alias]

This works perfectly! Thank you so much!

[lavender_alias]

thank you!

[lavender_alias]

haha no this is great! thank you!!