I have a table of over 4K rows. The columns are: Site, Object, AD Group, SP Group
I need to be able to display a summary of this data which shows the values in the "SP Group" column for each unique value in the "AD Group" column. This is a rough mock-up of the results I'd like to see.
The size of the data set means I can't just do it via sorting. My instinct is that there has to be a way to make this work with a pivot table. The challenge seems to be that I want to display text values.
I tried to do it using counts, with one type of group as the rows and the other type as columns. However, there are over 100 AD Groups and over 400 SP Groups. This does not create a usable summary.