.
Your description is confusing. But not a problem.

Create a sample worksheet and post it here for a visual representation of what you are seeking. It is understandable that the
worksheet will not function yet as you envision. However, it will provide a starting point for someone to better understand what
you are describing.

If you can ... provide a 'before' and 'after' view of what your data will look like. That also provides a better understanding of
the goal.

Thanks.