Sorting Issue

I’m new in this forum – and found out a lot of very helpful info.
For now I have a question how to sort my sheet with the following configuration:
In row 1 I have merged every five cells – groups of five. In merged cell I have the names.
For each name I have specific five columns. Now how to sort the names with all grouped columns? In other words – how to sort the names and keep group of five columns together with the name?
I’m not sure if it is fully understandable.
Thanks in advance
Mada

Could you provide an example please?

Originally Posted by arthurbr

Could you provide an example please?

I've Attached the file - before sorting and what I try to get after sorting
Regards
Mada

Short of using VB ( which I am no expert in) I don't know.
Beware though for merged cells, they tend to be a nuisance when one has to analyze data.
Good luck