Delete rows containing ""

[Waninio]

Hi guys,

The problem seems more complex than it really is but here I go

I've attached my file so you can have a closer look at it. If you open the file you will notice a column called "volgnum", this is the id of the dataset. Beside the volgnum there are 32 columns ranging from a, bel_a to p, bel_p. These columns (the lettre and bel_lettre) belong together.

The desired output I need is a table that contains the following:
volgnum (this is the id) - measure - choice - importance

At the moment I've got the volgnum folowed by 32 columns. 2 tasks:
1. What I need is that these 32 COLUMNS are transformed into 16 ROWS with the above structure: volgnum - measure - choice - importance.
2. But as you can see, in my spreadsheet there are a lot of blank cells so I need them deleted to.

I started another spreadsheet and tried to define a formula to create these separate columns, however I'm not able to solve it and it seems a bit too simplistic. The code:

volgnum measure choice importance
613
837
1029
1136
1146
...
1399 a 2
1437
833
1348

An example of the code in the cell 613 - measure is: =IF(ISNUMBER([Buspotentie.xlsx]Sheet2!$B2);$B$1;"")

As you can see, volgnum 1399 has got a value in the spreadsheet. So it's obvious that the code returns a value.

I hope you guys can help me, further explanation is off course no problem.

Thanks in advance