Merge and remove duplicates

[villival]

Hi Team

i have 11 -12 excel sheets , need to merge all of the sheets and the remove duplicate rows,

guide me on this

 

[GraH - Guido]

Google Power Query consolidating worksheets + remove duplicates. One hit would be

https://www.google.com/url?sa=t&source=web&rct=j&url=[URL]https://m.youtube.com/watch?v=P2kHy7ii4wc&ved=2ahUKEwiF7IravJT5AhUKOuwKHV4dCK4QFnoECA0QBA&usg=AOvVaw12dqegYAbpB-CPeGalBnGO

[/URL]

 

[villival]

Google Power Query consolidating worksheets + remove duplicates. One hit would be

https://www.google.com/url?sa=t&source=web&rct=j&url=[URL]https://m.youtube.com/watch?v=P2kHy7ii4wc&ved=2ahUKEwiF7IravJT5AhUKOuwKHV4dCK4QFnoECA0QBA&usg=AOvVaw12dqegYAbpB-CPeGalBnGO

[/URL]

unable to view the video

 

[pecoflyer]

With a little attention you could have extracted the YouTube link from the provided answer. Is that too much to ask ?