Hi All,

Trying to get some help here.

I am trying to get users to log their issues onto a Tickets/ Form with some basic information such as below:

Issue: 1 2 3
Ticket ID:
Description:
Required solution:
Value of Fix: Low/ Mid/ High
Length of Fix: Short/ Mid/ High

Using the information collected, I am hoping to create a matrix table (with Value of Fix : Low/ Mid/ High on the vertical axis, and Length of Fix on the Horizontal Axis.

Time Frame
Short-term Mid-term Long-term
Value/ Utility Low Test case 1 xy client tech development 0 0

Medium Test case 2 xy client tech development roadmap 0

High Test case 3 xyz client tech development roadmap roadmap


Am wondering if there is anyway Excel can populate the matrix for me? I wanted the detail to be appearing in the matrix (wheras pivot tables display COUNT or SUM which does not have the details) Or even dynamically update the matrix when there are changes to the source data?

Any help is really appreciated!