Remove Null to make 1 Single table

EmilAlteryx01

How can I eliminate null values from cells to consolidate them into a single table in Alteryx?

Sample Input 

Don.Bosco School
Record	Name	Marks	Sixth	Name	Marks
1	Shruti	100	Fifth	[Null]	[Null]
2	Elaine	80	Fifth	[Null]	[Null]
3	Nethra	60	Fifth	[Null]	[Null]
4	John	60	Fifth	[Null]	[Null]
5	Max	50	Fifth	[Null]	[Null]
6	[Null]	[Null]	Sixth	Shruti	90
7	[Null]	[Null]	Sixth	Elaine	80
8	[Null]	[Null]	Sixth	Nethra	50
9	[Null]	[Null]	Sixth	John	60
10	[Null]	[Null]	Sixth	Max	55

Sample Output 

Record	Name	Marks	Sixth	School Name
1	Shruti	100	Fifth	Don Bosco
2	Elaine	80	Fifth	Don Bosco
3	Nethra	60	Fifth	Don Bosco
4	John	60	Fifth	Don Bosco
5	Max	50	Fifth	Don Bosco
6	Shruti	90	Sixth	Don Bosco
7	Elaine	80	Sixth	Don Bosco
8	Nethra	50	Sixth	Don Bosco
9	John	60	Sixth	Don Bosco
10	Max	55	Sixth	Don Bosco

vizwithdan

Hi,

You can use the same logic in the Formula tool of the original solution I provided.

They are just IF statements to say if one column is null then take then take the original value and if not take the new one

It'll be worth you digging through my original solution in order to learn how to complete next time....learning is winning! 

Thanks

Danny