I am importing a csv matrix (non spatial table)

|ALLIER | -     |10    |200
|AISNE  |70     | -    |100
|ALPES  |10     |100   |-

What I want using Qgis

|FROM   |TO     |VALUE
|AISNE  |ALPES  |100

My real data displayed in LibreOffice Calc (my matrix is 100 x 100)


closed as off-topic by DPSSpatial, Fran Raga, ahmadhanb, Taras, Erik Jun 25 at 14:40

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions relating to general IT or with no clear GIS component, are off-topic here but can be researched/asked at Stack Overflow (software development), Super User (computing hardware and software), Database Administrators (relational databases) and other SE sites" – DPSSpatial, Fran Raga, ahmadhanb, Taras, Erik
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    Perhaps this is something better asked on another forum - however, you should simply use an application like LibreOffice Calc (spreadsheet) to pivot the data and re-load it into QGIS from the pivot table instead. – DPSSpatial Jun 24 at 15:58
  • How have you imported that into QGIS? As a non-spatial table? – Spacedman Jun 24 at 16:01
  • Yes non spatial table – Wilcar Jun 24 at 17:25

Browse other questions tagged or ask your own question.