Matrix Style Sheet

New Contributor



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 Replies
best response confirmed by scottfos (New Contributor)

@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.

Screenshot 2023-05-12 at 06.16.32.png

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