Another option is to use the Data Consolidate command...
Input the ranges with all boxes checked and 'Count' selected.

When it's run, resize columns then use EditReplace "COUNT(" with "N(" on
numeric columns or "T(" on text columns.

Now you can copy these rows to a new worksheet using Alt+;

[Note: to avoid blanks you can use use 'lookup(9e99,' or 'lookup("zzzzz",'
for the replacements instead]