Multi Row Formula to Make te Below Rows Nulls

Question

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 ?

Multi Row Formula..xlsx

AngelosPachis · Accepted Answer

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 Answer

That Helped. Thank you so much for the response.