I would like to reshape my data from wide to long format. My headers are dates every quarter so 31-1-2000 31-3-2000 30-6-2000 31-12-2000 31-1-2001 etc. and my ID value is Country so in column A a list of around 200 countries
I tried changing my headers to be something in the ballpark of Q1 2020 Claims to add a stub to it but even when doing this i cant seem to get the correct result of each country having all 81 quarters list seperately
Ive added a picture below to show what my data looks like at the moment.
Array