Combine and Unique Query Results|Power Query|Excel Forum|My Online Training Hub

Couldn't attach file

We are looking at two different markets and books are associated with one or the other and sometimes both.  what I am trying to do is provide a power query folder that will do 2 things  

1. Keep numbers unique (combining duplicates)

2. When a number is registered in both or if the are more categories (it combines and shows both on the same line)

    example would be and item from 2 different sheets 

SKU        Name                                        CS Category                             HS Category 

9993      Favorite Poems Old and New        K5 Beginning

From other file

SKU        Name                                        CS Category                             HS Category 

9993      Favorite Poems Old and New                                                     4th grade accessories

Result desired

SKU        Name                                        CS Category                             HS Category 

9993      Favorite Poems Old and New        K5 Beginning                            4th Grade accessories