In MYSql, I have a table that looks like this:
[Id] [Col_names] [Values]
1 col_1 val_1
1 col_2 val_2
1 col_3 val_3
...
1 col_n val_n
Basically, I want a query that returns me this output:
[col_1] ... [col_n]
val_1 val_n
Where the [Id] column identifies a single row (e.g., the observations of the [Values] column for all rows with Id = 1 corresponds to the values of the first row, the observations of the [Values] column for all rows with Id = 2 corresponds to the values of the second row and so on).