Hi,
I have 2 sheets of data, each with a unique key. Lets call them "Problems" and "Fixes"
Now each Problem is unique, however Fixes can apply to multiple problems
Eg,
Problems are:
10,11,12,13
Fixes are:
20, 21, 22, 23
Problem to fix relationship:
10 - 21, 22
11 - 20, 21
12 - 20 ,21, 23
13 - 21
If that makes sense.
So what i want to do is a data dump pulling out all the problems that apply to a certain scenario, and automatically list the fixes next to the problems.
I'm having trouble working out how best to structure this. Any ideas?
Bookmarks