Replicate for multiple row

SH_94

Dear community,

May i know how to write the formula in order to derive the result below to replicate the data? The objective is to check the column A if contain the "period", if yes, get the column B as Month Ouput. If no, then continue to use the previous data that contain "period".

Many thanks for the help.

Data Input.xlsx

DataNath

Hey @SH_94, for this request we can use the Multi-Row Formula with the following expression:

if [Decription] = 'Period' then [Detial] else [Row-1:Month] endif

Fill down month.yxmd