Partition of data by a condition & Selectively changing the values of a column

[Nidhin123]

@ipazin

TRUE => $Product$.

Awesome! >i dont know how to thank you enough.saved my day!

Since you are so good ,it will be of great help if you could look at the below question of mine.Please comment if my request is not clear

Rule engine for Merging two columns of data

Hi All, I have a data set which contains two columns ,month1, and month 2 along with other variables .Month1 will have values Jan,Feb,March till the current month and some nulls(even though it is with in the current month in Month2).In Month2 we have all the 12 months.Wherever we have data for Month1 , Month1 and Month2 will match. I need to filter Month2 for all the months till Current Month.Could you please help me to find by which I can achieve this. Please refere the attached excel for your…