2 columns should be generated.
One with the colum names in the rows and one with the values .
Just think about the inverse: split.
To know which value goes to wich column, you need a column with the target column name.
If you don't need this column, you can delete it.