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
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
Thank you I have watched the video
Going to try and follow