Authorship analysis: Number of author/authors per document

How to create a table of number of authors per document for a bibliometric analysis article (Table 13 from Cikgu Mawar template). From the SCOPUS database, export RIS file of selected documents, open it in Harzing Publish or Perish (PoP) software, get the PoPcites files and open it (in Excel file), insert PIVOT table, then follow the steps in the video. I also presented how to put the formula of percentage value in an Excel table.