Combining multiple files

[salsawarrior]

Hello friends,

I am a newbie to both this group and to Excel. Need help. I spent the last couple of days reading and watching Youtube and still can't figure out how to combine lists on my MS Office 2019.

I have customer sales for the past 5 years. Each year is a separate file. Some customer are the same some are different.

Question: 1) how do I combine those 5 files? 2) where customer is same - I like to not duplicate on the row 3) the columm will show sales for each year.

Attaching an example for your review.

Thank you for reading and support!!!

Conrad

[alansidman]

I have joined the two tables using Power Query. File is attached.

Review PQ
In the attached file
Click on any cell in the new table
On the Data Tab, click on Queries & Connections
In the right window, double click to open Query
Review PQ steps

M-code basics:
- "let" is the start of a query
- "in" is the closing of a query
- each transformation step sits in between those 2 lines
- each step line is ended by a comma, except the last one
- "Source" is always the first step (Source Data)
- After "in" you have the last step referenced

[Logit]

.
Another consideration :

Please Login or Register  to view this content.

[salsawarrior]

Thanks, Alan. The spreadsheet you sent still has no changes?

[alansidman]

Look at Sheet2. Sorry, I mis-copied your original.

[Haluk]

As an alternative:

Please Login or Register  to view this content.

[Haluk]

While cleaning my desktop, i found the attached file which seems i haven't posted before ....

The code simulates a Full Outer Join with using ADO & SQL;

Sample file is also attached.

Please Login or Register  to view this content.