See table at cell E1 of the sheet format needed of the attached.
Tt's a Power Query solution which unpivots the data. It includes blanks as you have in, for example, cell C243. If you don't want this then remove the ReplacedValue step from the query.
If you change the source data on sheet data, you'll need to refresh the result table by clicking on it somewhere and choosing Refresh, or click the Refresh button in the Queries & Connections section of the Data tab of the ribbon.