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 ?
Solved! Go to 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
That Helped. Thank you so much for the response.