Pasting the count of the files and data under the the column

Hello!

I want to paste the data like above image
Basically i got the count of available files from the folder’s ane i got the files which are pan no’s from the folders

Know i want to paste the count of each folders
Under the folder name column like above image.

Example
CAMS KARVY NDML Total count
3 4 6 13

Example

CAMS KARVY NDML
JEXPE522W HERTU1EE FGTER15283

and remaining name of folders like BSE DOTEX etc are some time not available in their website so i want that under that column it should right NA