This is another post inspired by a real life piece of work I did. The participant has a cash book with a list of codes and totals. They wanted to see the analysis done in a particular way. This could also have been done with a pivot table but this is the way they wanted it.
This is the starting file. You can download it here. Please note the data has been generated by AI.
The functions I have used are unique() and transpose().
I also used the if() function