Combining Spreadsheets

[NBPSE]

I'd like to combine 2 spreadsheets. The first spreadsheet is a much larger full and complete list of data. The second spreadsheet is a summed list. What is the best way to combine spreadsheet 2 to spreadsheet 1. What I need to do is combine the second spreadsheet with the first, grouping the summed amounts on the second spreadsheet to the largest subsection in the first. For example, Spreadsheet 2 apples need to be combined with the Gala apples in spreadsheet 1 because that is the highest total weight in the first spreadsheet for the Apples grouping.

Spreadsheet 1

Apples

Gala - 5 pounds

Cosmic 3 pounds

Red - 2 pounds

Bananas

Yellow - 4 pounds

Green - 2 pounds

Spreadsheet 2

Apple - 2 pounds (should combine with Gala Apples)

Banana - 1 pound (should combine with Yellow bananas)

[abacon]

@NBPSE Is there a specific identifier that details why the apples in spreadsheet 2 should go with Gala? Without seeing the data I would say to do a join but without having a specific key to join on, it's hard to fully help.

Are you able to post the full dataset or a test dataset that is similar so we can help further?

Bacon

[Gaurav_Dhama_ · Accepted solution]

Based on the available information, I would find the max pound per fruit, then join it with the fruit type in second spread sheet. Attached is a workflow which gives result as mentioned.

[NBPSE]

This works, thank you!