How to make rows null dependent on certain values?

overhead_press

I have a dataset and I am wondering how for each of the same ID, anytime when the Row Type is equal to "Difference" starts to be Null, then all the other Row Types of the same ID will also become null? Thanks in advance! 

sample:

ID	Row Type	1	2	3	4	5	6	7	8
1	Calc	10.0	11.0	12.0	13.0	14.0	15.0	16.0	17.0
1	Difference	0	0	0	Null	Null	Null	Null	Null
2	Calc	10.0	11.0	12.0	13.0	14.0	15.0	16.0	17.0
2	Calc2	11.0	12.0	12.0	12.0	12.0	12.0	12.0	12.0
2	Difference	0	0	0	0	Null	Null	Null	Null

Desired output:

ID	Row Type	1	2	3	4	5	6	7	8
1	Calc	10.0	11.0	12.0	Null	Null	Null	Null	Null
1	Difference	0	0	0	Null	Null	Null	Null	Null
2	Calc	10.0	11.0	12.0	13.0	Null	Null	Null	Null
2	Calc2	11.0	12.0	12.0	12.0	Null	Null	Null	Null
2	Difference	0	0	0	0	Null	Null	Null	Null

grazitti_sapna

@overhead_press , Please find my workflow attached and accept my solution if it was helpful.

Thanks!!

Column_value_change.yxmd