Replace F8, F9, with the above value

[Rahul_Analyst]

Hi,

I have a data attached as a sample. Want to populate it in column B as like attached output. 

Could you please suggest me how to do it ?

[atcodedog05 · Accepted solution]

Hi @Rahul_Analyst 

Here is how you can do it.

Workflow:

Hope this helps : )

[Luke_C]

Hi @Rahul_Analyst 

Here's one way with a multirow tool. It will check to see if it matches the pattern of F + some number, if so it'll take the row above's value.

[Rahul_Analyst]

@atcodedog05 , wow, thanks again. I want to be an expert like you:)

[Rahul_Analyst]

@Luke_C Thank you. 

[atcodedog05]

Happy to help : ) @Rahul_Analyst 

Cheers and have a nice day!