I am trying to find a way to automate grouping and names based off of a unique id.
For example, each program has a unique Program ID but may have five different Program Names over time. In the example below, we would like the program ID 40909 to have one program name Poker After Dark | Leave it to Seaver | Day 1 and show the total views across all program names related to that program ID.
I know this can easily be done manually, but because names are changing every day, I would like to find a way to automate this.
Please attach a packaged workbook and explain little more on what you need . I found it confusing.