I’m trying to combine two csvs with identical headers into a single CSV and combine any matching strings and values together. After hours of playing around with various combinations, I’m stumped!
Table merge creates a join and therefore a separate copy of matching items. Merging creates a delimited string with the numbers in?
What am I missing here?
I have a list of SKUs and a Stock Qty. I already know that some skus will definitely match, and when they do match I want to Sum the stock qty.
In Excel this is just a pivot table but I’m struggling to understand where I’m going wrong here?
I’ve tried basically every type of merge,unpivot and their options but something still isn’t right here!