I have a table (CSV) with statistical data for different neighbourhoods in a city (population according to different age categories).
My problem is that the neighbourhood doesn't have one field per category, but instead they have one row/feature per category in the table (i.e any given neighbourhood has 7 features/rows in the table).
I want to merge these features so each neighbourhood only has one row, to calculate child density. I can't figure out to do this when it's only a table, as the 'merge selected features' is disabled.
I have tried joining the table to a vector layer of the neighbourhoods but a lot of data is then lost. How can I do this?
*Edit: Example of what it looks like (not real data):
And so it goes on. Each neighbourhood has at least seven rows/features, and sometimes from several years. I want all age categories to be in the same row for the year that I'm planning on using.