Separating single row data into 2 fields

I’m trying to make a time series panel but all the data from my query are
being received as different fields/columns and with that, every data is represented in the same date.

I believe there should be only 2 columns, ‘value’ and ‘date’ so the time series works properly. Anyone can help?