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

Listbox, mouse wheel scroll issue

Updated October 22, 2015 08:00 AM

Formula issue Microsoft Excel

Updated July 02, 2015 16:00 PM