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.

[DataNath · Accepted solution]

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

[Sebastiaandb]

Hi @SH_94 ,

I believe this is what you're looking for :D!

Let me know if this is working for you.

Greetings,

Seb