The cause might not be how you use functions or Power Query, but rather the structure of the original Excel table. Excel is a convenient tool that allows for free-form input. However, because of that ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results