Creating an indicator based on the blanks in the columns

[sriniprad08]

Hi Team,

I have a situation where i need to create an indicator based on the blanks. For e.g below if i have one blank consecutive then the indicator should be 1 year, if two blanks consecutive then 2 years etc.. i have marked in yellow.

Please let me know how to go about this 

thanks,

Sri

ID	2016	2017	2018	2019	2020	indicator
111	33	33	33	33		1 year
112	333	333	33			2 year
222		222				3 year
333	33					4 year
444	33	33	33	33	33	Regular
555		33		33	33	Regular

[atcodedog05]

Happy to help 🙂 @sriniprad08 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂