How to identify all species observed in each cell of a research grid

Question

I have created a grid map as a shapefile. I have added a point layer that includes “species name”, coordinates and etc. I put a part of it below.

Now, My problem is, when I use “count points in polygon” tool, the “species name” is missed and I cant see the “species name” in the attribute table. This tool counts the number of points only such as this: Left bottom right top number of point

If I want to ask my question in another way, How to export the species names which fall into each cell. It is very important for us to know what species are inside each cell.

Answer 1

On the grid layer, create a new attribute with Field calculator and the following expression. It generates you a text field for each grid cell, listing the species that are located in this cell.

Be sure to set Output field type to Text (string) and set an Output field length long enough to fit the whole list.

array_to_string (
     array_distinct( 
        overlay_contains( 
            'layer_species',  -- adapt the layer name
            "species"  -- adapt the name of the attribute
        )
    )
)

The expression used as a dynamic label: the black labels indicate which species (red dots with red labels) are inside each cell. Duplicates are removed to get just a list of the names of species that appear inside the cell:

Answer 2

One way of doing this:

1. First run Join Attributes by Location (vector menu>Data Management Tools) - this will create a memory layer called Joined Layer.
2. Then save Joined Layer as a geopackage. In the screenshot below it is called points_by_grid
3. Connect to the new geopackage using the DB Manager and use a sql expression like this: