Hello everyone,
I have a problem with advanced sorting (or at least I hope it needs some more advanced formula).
Basically I will try to explain what I would like to achieve on the screenshot.
I would like to get to the table in blue using 1 array formula or two separate formulas using (for CODE and VALUE) but I have no clue how to do it
.
Do you have any ideas?
Thank you!
I have a problem with advanced sorting (or at least I hope it needs some more advanced formula).
Basically I will try to explain what I would like to achieve on the screenshot.
I would like to get to the table in blue using 1 array formula or two separate formulas using (for CODE and VALUE) but I have no clue how to do it

Do you have any ideas?
Thank you!