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

Updated May 29, 2017 12:01 PM

Updated March 27, 2018 13:01 PM

Updated December 01, 2018 22:01 PM

Updated December 19, 2018 07:01 AM

Updated February 07, 2019 07:01 AM