Total QGIS noob here who started using the software last night, I've looked all over SE for a solution but nothing helped.
I joined a shapefile to a CSV. The join field is 'market_number', target field is an area number column on the shapefile. However, looking at the attribute table on the shapefile only one 'market_name' shows when the csv source has multiple i.e. there is one of San Diego, Tucson when there are two. Is this by design or am I doing something wrong?
Also, could areas on the shapefile layer change color when a 'market_name' like Tucson has multiple 'block' listed given that the field is only letters? I messed around in Open Fields Calculator and 'block' field now shows as numbers in the Expression String Builder but then what?