Matrix Style Sheet

[scottfos]

Hi, 

I have a sharepoint site that I use for employee competency management one of the lists stores roles and their associated competencies.

Is there a way to create a report that displays the information in a "matrix" style ? similar to below so that when the information is changed or updated in sharepoint the matrix is updated? (i have the data connection setup that syncs the table within the spreadsheet)

[#2 · Accepted solution]

@scottfos Wouldn't a pivot table do just that? Row in the Row field, Competency in the Column field and count of Role in the Value field. Then use conditional formatting to color all cells in the table that are equal to 1.

[#3]

Thanks @Riny_van_Eekelen that worked great for me, its time to learn about pivot tables.