Prep for charts with a regex driven table

The last item needed for the dashboard is a regex aggregate table. This aggregate table will dynamically change based on the values in the filtered table.

The marketing director at your agency would like to see a pie chart and a column chart in the dashboard, and this regex aggregate table will make the creation of those charts easier.

The regular expression in cells L2:L4 is already complete. As you can see, by appending .* after the first few letters of the ad group, you can match each one perfectly.