Hi @Nicholas Jimenez
I suggest you replace blank values with "0" in Power Query then use "Unpivot Columns" function.
- Go to Excel > Data group > Get & Transform Data group > Click Get Data > From File > From Excel Workbook, load your data into Power Query.
- Go to Transform tab > Table group > Use First Row as Headers.
- Select value columns > right-click on the first row > Replace Values > Enter "null" into Values to find, enter "0" into Replace With.
- Keep selecting these columns > Transform tab > Any Column group > Unpivot Columns (If you do not replace null values, then they will be removed after doing this step, you my replace 0 with null values back later).
- Rename the headers.
- Right-click the Date column > Change Type > Date.
- Go to Add Column tab > From Date & Time group > Date > Day > Name of Day, then rename the header to "Day".
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.