I'd like to create a time series animation in QGIS 3.14. My data is structured in a way that the dates are given by the field names. I have field names like "country_name", "1/15/20", "1/16/20", "1/17/20" and so on. For the temporal controller in QGIS it seems as I would need to have the dates all in one field. I can not simply transpose the data (switch columns and rows) in Excel since I would need a seperate country row for every date.
Is there a way how I can make this data usable for QGIS?