Forum Discussion
SneakyFunk
Apr 30, 2025Copper Contributor
Excel - Pivot with permutations & combinations
Hello everyone, I've got a problem with excel that I've not managed to solve and search has not been too helpful either since I'm not sure how to put the exact issue into words. I will be inspecti...
OliverScheurich
May 01, 2025Gold Contributor
An alternative could be as shown in the attached file. This solution works in legacy Excel such as Excel 2013. If the result in columns J to O needs to be returned without empty rows then there is a formula as well.