Hello,
I would like to transform this table in order to make it readeable to qlik. I would like to have all the fields in the same row and then do a crosstable. My problem is that I have a field (sex,men women) over a field (year) and Alvacete,Alicante ... in the left. I would like to have all in the same row and do a crosstable, that is the right way to do it, right?
| | Men | Women |
| | 2018 | 2017 | 2016 | 2018 | 2017 | 2016 |
| 02 Albacete | 194.158 | 194.743 | 195.841 | 194.628 | 195.289 | 196.277 |
| 03 Alicante/Alacant | 911.097 | 904.711 | 911.173 | 927.722 | 920.621 | 925.286 |
| 04 Almería | 361.319 | 359.676 | 358.223 | 348.021 | 346.996 | 346.074 |
| 01 Araba/Álava | 162.175 | 161.354 | 160.240 | 166.693 | 165.220 | 163.886 |
| 33 Asturias | 490.738 | 493.911 | 497.852 | 537.506 | 541.049 | 544.756 |
