Your current layout is probably going to be an issue. You would be better served if your data was normalized. If you upload a sample (dummy up confidential data) and a mocked up solution so that we can understand completely your need, then we might be able to help. Not enough current information to offer up a workable solution. 5-8 records should be sufficient.