Create a Unique List from multiple data lists, Append Data, Remove Duplicates - POWER QUERY

[@rexbk]

Beautiful. Thanks! Subscribed.

[@karthikm1435]

Sir I have data in two columns both are same. In that data 1 column data is correct, remaining coloum there may be spelling mistake. I need to know missing letter or number. Is there any possible. Kindly advise me.

[@manuvincent9793]

How to do the same in Google sheets