summarised table in query editor comma missing

[Pandadev]

Hi I have 75 tables which have the following columns matched taht I want to add a summarised table to in query editor.

The columns are QC Check and Researcher

Is it possible to create a table showing the QC Check and count of rows per researcher

i tried to research this but am getting an error saying comma missing  , plus some of the tables have spaces how would they be added , would it be in this format [my table]

= let
Source = Table.Combine({Table.SelectColumns(24_not_followed_by_ZZ, {"QC Check", "Researcher"}),
Table.SelectColumns(41_followed_by_Purchased, {"QC Check", "Researcher"}),
Table.SelectColumns(74_not_followed_by_ZZ, {"QC Check", "Researcher"}),
Table.SelectColumns(A3_Followed_by_99, {"QC Check", "Researcher"})}),

#"Removed Duplicates" = Table.Distinct(Source)
in

#"Removed Duplicates"

The output I was looking for

QC Checker                          Researcher  Rows

24 not followed by ZZ         DC               4

24 not followed by ZZ         BA               2

41 followed by Purchased   DC               9

41 followed by Purchased   RM              22

[Pandadev]

I managed to work it out myself thanks for your help on thie , I added 

#"Grouped Rows" = Table.Group(Source, {"QC Check", "Researcher"}, {{"Rows", each Table.RowCount(_), Int64.Type}})
in
#"Grouped Rows"

[edugoncalves · Accepted solution]

Hi @Pandadev ,

You're wrongly mentioning the tables, by default, it should be like this: #"Table_Name"

With that in mind, you have the corrected code here:

let
Source = Table.Combine({Table.SelectColumns(#"24_not_followed_by_ZZ", {"QC Check", "Researcher"}),
Table.SelectColumns(#"41_followed_by_Purchased", {"QC Check", "Researcher"}),
Table.SelectColumns(#"74_not_followed_by_ZZ", {"QC Check", "Researcher"}),
Table.SelectColumns(#"A3_Followed_by_99", {"QC Check", "Researcher"})}),

#"Removed Duplicates" = Table.Distinct(Source)
in

#"Removed Duplicates"

Best Regards,

Eduardo

[Pandadev]

Thanks that worked , is there a way to just get the cound of Researcher

like

24 not followed by ZZ         DC               4

24 not followed by ZZ         BA               2

41 followed by Purchased   DC               3

41 followed by Purchased   RM              2

at the moment it is showing 

24 not followed by ZZ         DC

24 not followed by ZZ         DC

24 not followed by ZZ         DC

24 not followed by ZZ         DC

24 not followed by ZZ         BA

24 not followed by ZZ         BA

41 followed by Purchased   DC

41 followed by Purchased   DC

41 followed by Purchased   DC

41 followed by Purchased   RM

41 followed by Purchased   RM