Forum Discussion
Data
Test
It looks like you're trying to unpivot the data. PowerQuery may be your best option:
Top level overview:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
A bit more in-depth:
https://learn.microsoft.com/en-us/power-query/unpivot-column
Top level overview:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
A bit more in-depth:
https://learn.microsoft.com/en-us/power-query/unpivot-column