The requirement sounds fairly clear, so it's entirely possible that one of the brethren will come back with a solution all worked out for you.

To improve your chances, offer a set of sample data and desired results. To improve them even more, share your first attempt at coding a solution and the output you got.