Hi,
your question, wanted solution and data structure is difficult to understand.

Could you please provide a sample sheet with your data and how you want the result to look like. By this, someone will probably have a bigger chance to help you.

Kind regards
Bjorn