Forum

Combine and Unique ...
 
Notifications
Clear all

Combine and Unique Query Results

3 Posts
2 Users
0 Reactions
150 Views
(@sward704)
Posts: 3
Active Member
Topic starter
 

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

 
Posted : 16/06/2022 6:58 am
(@mynda)
Posts: 4762
Member Admin
 

Hi Shawn,

Welcome to our forum! 

Please see this post on merging lists in Power Query.

If you're still stuck, please create a small Excel example file that illustrates the issue and we can help you further.

Kind regards,

Mynda

 
Posted : 16/06/2022 8:23 am
(@sward704)
Posts: 3
Active Member
Topic starter
 

Thank you I have watched the video 

Going to try and follow

 
Posted : 16/06/2022 4:21 pm
Share: