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

[Raj]

@EmilAlteryx01 
find the workflow attached

mark done if this is solved.

[vizwithdan]

Hi @EmilAlteryx01 ,

The solution for this is attached :)
Please mark as complete if this has resolved your query.

Thanks

Danny

[EmilAlteryx01]

Hey Danny,

Thank you for providing the workflow. I have some additional data to incorporate.
Could you please provide the formula needed to update the tool in order to achieve the desired output as described below?

[vizwithdan · Accepted solution]

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

[EmilAlteryx01]

yeah i used the same solution, but i keep getting the Parse Error.. ive been trying since a while - so reached out

[EmilAlteryx01]

Got the clue in ur reply - worked 

IF ISNULL([New Column]) THEN [Original Column] ELSE [New Column] ENDIF

[vizwithdan · Accepted solution]

The the key to it yes!
Please can you mark as the correct answer so I get my Kudos :) 

Thanks You! 
Danny