Calculating hours using pivot table

I think you need to make the table like this first. With that dataset it is up to you how you do next steps for your actual needs. Yo

Lesson	Hours	Teacher
Lesson 1	2	Paul
Lesson 2	3	Pete
Lesson 3	2	Paul
Lesson 3	2	Pete

1. Convert the Lesson table to a Table

Select any cell in the Lesson table

Press Ctrl + T

Confirm “My table has headers”

2. Load into Power Query

With the table selected

Go to Data → From Table/Range (Power Query Editor opens)

3. Unpivot the Teacher columns

Hold Ctrl

Select Teacher 1 and Teacher 2

Right-click → Unpivot Columns

 

4. Clean up

Delete the Attribute column

Rename Value → Teacher

 

Close and load

 

 

Your inquiry has been up for several days without a reply. I can't speak for others with certainty, but from my perspective I suspect that the reason for the lack of replies is that the sample data you do give is far too simple. Far too simple to create a Pivot Table from; so in effect you're asking anybody who might want to offer assistance to create their own more complete set of data. 

You would help us help you by posting a more representative set of data (still no real names) with multiple teachers, multiple classes, etc. If you're not able to attach an actual Excel workbook to your reply in this forum, put it onto Google Sheets or the equivalent and paste a link here.