Counting rows that do not have values and getting values from another table that does have values

[albertax]

Hi i have two tables that I need to be able to display the total values. They are set out as follows:

Table 1: System Data. Each entry has a row and a Business Unit and a Type to identify, and then i go through and count the number of rows. Easy

(This would be counted as four CCCs)

Table 2: User Submitted Data. Each row but has the values in a column for that particular date (week, month) and i need to be able to show them alongside the system data. 

All good and well. But the problem is Table 2 is not the same as Table 1 because in Table 2 each entry is submitted via a Microsoft Forms and instead of having rows with a Type in it, it has the values inside a column that never changes (e.g. CCC, LLC, OCC).

Screenshot below

Any ideas how I can get the values from the User Submitted data (singular rows with values, identified by each specific static header) to count along side the values in Table 1 (multiple rows, identified by Type)

[Anonymous]

Hi @albertax ,

There are several same columns in both tables. Can we identify the records by date, business unit and project then get corresponding values? What is the expected result?

https://docs.microsoft.com/en-us/power-query/merge-queries-overview 

Best Regards,

Jay