Hello, I am looking for a formula that could help me achieve the same outcome that I could do in Excel using an index & match array formula.
I am trying to group classification data based on the hierarchy. You can see from my excel screenshot below, ...