So the last file I attached seems to be correct?
Here's that pivot filtered for just index 12:
2022-11-27_161422.png
I've added grand totals for rows as well so that you can see the total length tallies.
The values for August and October seem to be right too.