I have this current dataset in which I am trying to convert into fewer columns as we go to moving it to a database there is less issues where columns names are types of activities.
Where instead would like to have each activity is its own row rather than the full day in one long row.

I have tried a brute force approach of iterating through each of the rows of each column one by one and taking the name from the index. But this approach is slow and would like to try my hand and ask for advice on more functional and quick approaches.

Dataset For Reference