Yes, there is, or rather: was.
In the ‘legacy’ versions, I had a UDF (user-defined function) =panova(groups; values) to accomplish this. You can of course install version 6.70 and ignore the suggestions to update to the NG series (version 7).
You need to be aware though that UDFs don’t transfer well to other locations. So, if you want to send your file to someone else, the UDF likely won’t work even if the other person has the Toolbox installed as well. That’s why I never really advertised the function so much. But I used it myself for situations just like yours.
I could easily make it available in the API, but give me a couple of days… Then you can write your own UDF and continue to use the version 7 series.
Actually, it occurred to me that I never removed the UDF from the legacy add-in. So you can just continue to use it with the current version 7 series!
Be aware though that it might be rather slow on 3000 iterations…
