how to list non-empty values from a column of data.

[setilvenstre]

Hi everyone,

I am far from being a pro in excel and I have a task at work that I haven't been able to solve so far.

The base of my problem is a set of risks to which there are two drop down menus, one for likelihood and one for impact respectively. for both there are five options. from these there are 25 different possibilities, all to which a specific number is assigned. once i have this specific number, i have to make the name of the risk show in a 5x5 matrix.

Since I'm not a pro, i came up with a not-too elegant solution.

i created a 5x80 table (5 columns, 80 rows, see attached: source1, source2), where a simple if function puts the name of the risk under the given number if it applies, otherwise gives zero. This way the task is basically done, although very unprofessional. what i would need is (possibly in a new table) to get rid of all the zeros and only have those fields that have risk names in them, all of them at the top of their column (see attached: goal). it is important that things should change if the original drop down menus are changed.

I am not sure if I managed to express my problem very clearly, but I'm really hoping someone will be able to help, since I've been trying to solve this for one and a half days now...

Thanks in advance!

Best,

Peter