How to pull Amounts from 2 different columns from one file into one column in another file

[jake8281]

Spoiler

 

How can I add the quantities for Table 1 from  Table 2  based on the category column in table 1 extracting the quantities from Column 2024 & 2025 from Table 2 

[alexnajm · Accepted solution]

Like this?

[jake8281]

Is there a shorter more efficient process for memory space ? 

[alexnajm]

With the data you presented, this is a valid solution - the only thing you could consider is replacing the Data Cleansing with another tool to clean up your data.

[jake8281]

my actual date is 8000 on the first file and 6000 on the second file

[alexnajm]

I wouldn't anticipate this solution taking more than a few seconds even with that many records - what issues are you seeing when implementing this solution?

[alexnajm]

You can use Performance Profiling (ACE Tricks - Ep. 5, Lagging Tools) to understand where your bottlenecks may be occurring, and then go from there to see which tools may be causing memory issues. But without seeing the issues, we cannot help further - this is a valid solution that works beautifully for the data you presented.

[nagakavyasri]

@jake8281 Another way:

[jake8281]

Thank you all for help.