I have this situation. I have two excel files, let's say, 1 and 2. I have a Key which is common in both the files with lot of blanks in the first file (never saw any primary key blank in my life). Let.s call it "Key Field".
I have a big dashboard with 20 worksheets. I need to join / blend for global filter. I only have two worksheets coming from second file, but the global filter is on the first file. All other data is mostly independent with no overlap.
What should be the best approach to solve this ?
Please check this blog.