Delete rows containing ""

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

Could you provide an example, maybe on the second sheet, of exactly what you would expect the output to look like?

Thanks for the replies guys, thanks.

Well the output I opt for isn't a calculation or that sort of thing but is merely a copy of cells from the file I added in the first place. What I ended up with is attached in this reply.

I managed to do it with a few shorter formulas that are related to the other sheet I posted in my first message. But it would be nice if it were possible to write this into one big formula or a VBA script. I'm completely new to VBA but I understand the basics of programming.

Thanks in advance!