Create a rights/responsibilities Matrix in Excel

by Francis   Last Updated December 06, 2018 15:01 PM

I want to create a nice overview of responsibilities in a system, and I have received an output of responsibilities entries in the system in the format of rows of username, responsibility description and responsibility ID.

enter image description here

I want to transform this list into a matrix such as the following:

I am at a loss as to how to create such a matrix with common Excel functions, however, I am guessing that it has to be simple in some way.

enter image description here

Answers 1

Select columns A:C

Under the insert tab select pivot table,

Drag the field UserName to the rows section

Drag Responsibility field to the columns section

Drag Responsibility_ID to the values section, and choose the value count.

enter image description here

enter image description here

enter image description here

December 06, 2018 14:55 PM

Related Questions

Select 1st day of each user id in excel

Updated December 19, 2018 07:01 AM

Text function in Excel isn't formatting year

Updated February 07, 2019 07:01 AM