How can I have a set of labels for a location, where the variables are within a single column?
What I am hoping for is to have placement of 'concentration' followed by depth at each location shown on label.
Example of my data:
Loc_ID (1, 1, 1, 2, 2, 2...) Depth_m (0.2, 0.5, 1.0, 0.2, 0.5, 1.0) Conc. (1, 0.2, <LOR, 1 ,no data, 0.2) etc...
I have tried CASE and coalesce. However, in an instance where there is no data, the label shows an empty line, which is not required.
I am using QGIS.