Power Query with notes in Excel

[Evans2]

Hi all,

Finding Power Query a really useful tool. I'm using it to import data from a database into Excel to track certain items. Each row contains data related to a unique item ID.

Once the data is imported to Excel, I would love to be able to create a separate column so that I can create notes. Once the data is updated however, the sort order on the notes column I created is thrown off and is no longer accurate.

Does anyone know a trick I can use to keep this from happening?

Thank you,

Evan

 

[Evans2]

Thanks for the link ImKe. Matt's write-up was very useful as well. I think I've got it now.

My problem was due to a duplicated product ID. Several product samples could be associated with each product ID causing duplicates. I thought I could simply create an Index column but things started to look wonky in my comments column after awhile.

In my source data, I found that each sample has a unique sample ID that I could pull into Power Query and merge with the product ID to create a new column per your suggestion. No more duplicates! I think everything should work fine now.

 

[OlaSa]

I just though a picture might help - follow ImkeF's link in the previous post.
//Ola

By Matt Allington