Forum Discussion
leighamarigoni
May 22, 2021Copper Contributor
Needing a format to merge cells
Hey guys, So Im currently trying to merge to cells that are in different columns. But they aren't keeping the numbers that Im needing them to keep when they merge. Is there a formula that Im com...
Yea_So
May 25, 2021Bronze Contributor
Even with advanced steps such as power query or power pivot, it is un-mergeable because of the values in the Host Jurisdictions as illustrated in the first example, what expression would one implement on which logic to use to keep which Host Jurisdiction (which I would assume to be multiple) in which case one would have to create a precedence table to support the expression otherwise one would be lost in implementing that expression ( where in the step was I in the decision expression?)