Multi Row Formula to Make te Below Rows Nulls

[DataPirate26]

I want to write a multi row formula to make the below rows as nulls if it has the same name as in the previous rows. I have attached a dummy data file to make it more easier to understand where i have provided the input data and how the desired output should look. Can anyone help me write this multi row formula ? 

[AngelosPachis · Accepted solution]

Hey @DataPirate26 ,

I used a multi-row formula tool to count the number each header appears. Then with a formula tool, I nulled the value in the header column if the count is greater than 1.

Hope that helps.

Regards,

Angelos

[DataPirate26 · Accepted solution]

That Helped. Thank you so much for the response. 

[Vaithi]

Hi Soumyadipsarkar26, This can be done in 2 ways. One using multi row formula and another using tile tool. Attaching the workflow for your reference.