Oct 11 2021 12:38 AM
Hello,
hope you are doing great today!
I'm looking for a way to merge a couple of thousands of rows - 50-100k/document. If the name (A1) is the same, then merge it with all other rows with that name and then add all of the values in B1 of those rows. So basically (see the image), start with the yellow sheet and end up with the green one.
Oct 11 2021 01:06 AM - edited Oct 11 2021 01:09 AM
Did you try PivotTable?
Update:
Sorry. I forgot you have many documents. PivotTable may not suit your needs.
Oct 11 2021 01:16 AM
Oct 11 2021 08:19 AM
@vitekprchal Sounds like something for PowerQuery. Connect to the data in the left table. Group by Name, Sum by Value. Shouldn't take too much time.