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 Please attach a sample workbook instead of hard-to-read photos.
If you cannot attach a file here, upload it to Google Drive, OneDrive or similar, and share a link to the uploaded file in a reply.
