Forum Discussion

cbattinieri's avatar
cbattinieri
Copper Contributor
Oct 15, 2019

Power Query Merge Issue

I am having trouble merging queries. Both columns are cleaned, trimmed, and the same data yet none of the rows are matching. Any suggestions?

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Where does that data come from? Any unprintable characters in there by any chance (like character 160). If the data originates in Excel, what happens if you look at it in the formula bar, any leading or trailing characters?

Resources