Hello everyone,

I am fairly new to stata, so I have some issues with converting my data file into something workable for my analysis.
I have attached a screenshot of the data.

What I need is to convert all the information in the screenshot into a row of data. Right now the variable "opleidingen"(column1) is shown 27 times and column 2 ("variabel") shows all the variables I have data on. Is there a way to have the entry "vmbo economie" thats pasted 27 times as a single entry in a row, and have all the cell values of column 2 as variables in seperate columns?

the end result would look like so:
verwachte uitbreidingsvraag tot 2020 verwachte vervangingsvraag tot 2020 verwachte baanopeningen tot 2020 ........ ........... niet-westerse allochtonen
vmbo economie 33
(next entry)
I guess to summarize, how do I transpose the data from column 2 onward, and then merge everything to a single row.

Any help is much appreciated.

Kind regards,
Niek

Array