Tidy way to collapse rows when a spread/pivot won't work

Hi,

If your question has been answered, can you mark your question as solved

It will help other knows the status of the question right from the list of question or by searching for related topic.

Thank you.