Forum Discussion
Group By data in 2 different sheets
Hi Anonymous
You can use Merge Queries feature to bring data from one table into another table. Select one or multiple matching column pairs in both tables for joining. Column headers don't need to match between tables. However, it's important to note that the columns must be of the same data type, otherwise the merge operation might not yield correct results. For example,
After selecting OK in the Merge dialog box, a new column will be added to the base table with the same name as your right table. This column holds the values corresponding to the right table on a row-by-row basis. From this new table column, click the expand icon on column header and switch to Aggregate. For the field you want to sum, select Sum aggregation type for it.
After selecting OK, this field will be sumed up according to the matching columns.
For detailed guidance, please refer to Merge queries overview
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
So something like Table 1 has a list of Material Codes by Size and Table 2 has Inventory by Pallet/location?
I'd use GroupBy on Table 2 and ensure you use correct criteria...
In example below I'm grouping by Material Code and Size (DimA and DimB) and Summing InvQty to output the Total Inventory of each item. The results would be a line for each Material/Size with the total Qty we hold in stock (so in essence =SUMIFS(InvQty,MatCode,"Material 1",DimA,"Dimension A",DimB,"Dimension B")) then merge that back into Table 1.