I am trying to combine data from multiple files with multiple worksheet and the same schema:
I have 2 files: Sales A and Sales B. Looking to combine worksheets from each file to get results similar to my file Sales A+B with 2 tabs:
Source: Sales A Tab #W1#
Source: Sales B Tab #W1#
Expected Results: A+B Tab #W1#
Seems simple enough... read in both sheets, aggregate data, and output. Am I missing something?
User | Count |
---|---|
107 | |
82 | |
69 | |
54 | |
40 |