Hiding Or Removing Duplicates In a Report
I have a report on a sheet that has many duplicate values, and for the sake of nice presentation I would like them hidden. To further explain my situation, I have a sheet I am referencing that has tasks, days to complete, the week of completion of these tasks, and finally the avg days to complete a task per week. What I want this report to pull is simply the week of completion along with its corresponding average days to complete a task per week. I have been successful in that I was able to pull the two columns, and group them by week, however since there are multiple tasks, the rows are repeated over and over again. What I want is to filter it such that only once occurrence of any given week appears, this way I can show clearly and simply the week, and the avg for that week. I'll link some screen shots down below of what my report and sheet look like. Thank you all in advance for any and all help!
This is a screenshot of the sheet:
This is a screen shot of the report:
This is ideally how I would like it to look
Help Article Resources
Check out the Formula Handbook template!