Hi All,
Say i have the below scenario, wherever “kr” is there i need those previous values as “sh” and for “sh” of i have the previous value as “sh” then i need as “sh” only. So only for “kr” i need its overall previous value. For example:
column A output
-------- ------
sh null
kr sh
kr sh
kr sh
sh kr
sh sh
kr sh
kr sh
Please help me in this. Thank you in advance!!