Forum Discussion
combining different types of data from two tables
Hello, I have two spreadsheets exported from different databases. SheetA has two columns: studentID and studentName. SheetB also has two columns: studentID and awardsEarned. I want to combine...
Lenalex5 Power Pivot (PP) will probably work for you. Add the two tables to the Data Model (DM). Create a relationship between the studentID in the Awards table (the many-side) and the studentID in the Student table (the one-side). Now you can create a pivot table based on both tables as demonstrated in the attached file.
If your data needs cleaning-up, you might want to use Power Query (PQ) first. Load clean data from PQ into the DM and do the steps as mentioned above, or merge the two tables in PQ (resembling Excel's VLOOKUP) and load a smaller table back to Excel, listing all student names for all awards given. Also demonstrated int he attached file.