Selected Answer
What I would do is one of these 2 options:
- Use a macro to create a nice neat report page.
- Use the existing report page as a step in the process of getting the final one.
Option 1 is self-explanatory and maybe not what you want as it involves programming
Option 2: Create a new worksheet > go back to the Report sheet > select everything and hit Ctrl + C > go to the new worksheet and hit Alt + E + S + V Enter (This will turn all formulas from the Report sheet into the actual display values on the new worksheet).
Now, select columnd B to I on the new worksheet and go to the Data tab > Remove Duplicates > and hit OK.
Once you do this, it is easy to finishe the formatting as you desire. Also, it may look like a lot of steps but all of this will take less than 30 seconds once you get used to it.
I attached a sample of what it will look like if you follow the above steps - the new report is on Sheet1.