Help on Power Query Merging

Hi Mei_Jiang_Wu 

With the help of Power Query(PQ), you can easily merge all of your five tables.

Since you can only merge two tables at a time in PQ, you need at least four steps:

1. Using the Name column, merge Table 3 with Table 1 and give it a name as Course_1&3.

2. Using the Email column, merge Course_1&3 with Table 4 and name as Course_1&3&4.

3. Using the ID column, merge Table 5 with Table 2 and name as Course_2.

4. Using the Email column, merge Course_2 with Course_1&3&4 and name it All_Courses.

Points to note:

I assume that all of your tables have information for all students, so use Inner as Join kind.

For simplicity purposes, use the "Merge Queries as New" option.

Please let me know if it works for you.

Thanks

Tauqeer