This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The Cleanse Data tool removes all the leading and trailing spaces. The Summarize tool groups by ID and calculates the total records for each ID and the Sufficiency records for Employees and Managers. The formula tool does the math to determine if the comments reach the 50% mark and adds "Yes" in the "Both" column if both conditions are true
Note that your input data didn't match your results for ID 4, 4 records and 2 manager comments, so I added an extra record with no manager comments