Forum Discussion
Adding a column with custom values to a Power Query
- Jan 09, 2021
Please check in attached. I trim and lowcase product names to use them as ID, but if you data is clean it's not necessary.
SergeiBaklan The product names are unique and can serve as ID. But they're not "mathematical" and the list changes regularly (additions and deletions).
Taking this into account, how would you solve this in my simple example workbook?
So in sheet2 I need the list of products where I can manually add the SS value (0 or 1). But let's say prod02 is deleted in sheet1 and prod15 is added, how can sheet2 update with the new list of products without losing the SS values already assigned to still existing products?
Please check in attached. I trim and lowcase product names to use them as ID, but if you data is clean it's not necessary.