PowerQuery Excel - how to convert a schedule created in excel and convert to PowerBI dashboard

Ok. I will walk through the steps.
Since you mentioned you are using an Excel file I transfered my dataset to Excel. The source line now becomes

Source = Excel.Workbook(File.Contents("C:\YourFilePath\YourFileName.xlsx"), null, true),

Assuming your data is in sheet1 the next line will need to be

Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],

You should now have something that looks like...

This routine depends on the columns being type text so we need to add 

#"Type Change" = Table.TransformColumnTypes(Sheet1_Sheet, List.Transform(Table.ColumnNames(Sheet1_Sheet), each {_, type text})),

Note: This step was not in the original response and is written this way to allow the column count to increase or decrease dynamically in your source file.

You can now promote the headers 

#"Promoted Headers1" = Table.PromoteHeaders(#"Type Change", [PromoteAllScalars=true]),

If you use the UI to promote the headers it adds a change type row automatically. Delete that change type row step if it appears.

We now need to add a blank row since the eventual transformation is going to group the rows in two row groups and we need a row to "group" with the header row.

#"Insert Row" = Table.InsertRows(#"Promoted Headers1", 0,{Record.FromList(List.Repeat({""},Table.ColumnCount(#"Promoted Headers1")),Table.ColumnNames(#"Promoted Headers1"))}),

Now to demote the header row (Use Headers as First Row)

#"Demoted Headers" = Table.DemoteHeaders(#"Insert Row"),

Again, if a change type step automatically appears here, delete it.

Now we are going to create a list of columns from the table.

#"Table To Columns" = Table.ToColumns(#"Demoted Headers"),

Now, from the list that we created we need to split the list into groups of 2.

#"Transform List" = List.Transform(#"Table To Columns", each List.Split(_, 2)),

And now combine the list pairs into a single cells within the list, seperated by a space.

#"Transform List2" = List.Transform(#"Transform List", each List.Transform(_, (pair)=>Text.Combine(pair, " "))),

Turn that list back into a table

#"Table from Columns" = Table.FromColumns(#"Transform List2"),

You should now have a table that resembles...

Promote the first row as header (delete the automatic change type step if it shows up)

#"Promoted Headers" = Table.PromoteHeaders(#"Table from Columns", [PromoteAllScalars=true]),

Now select Column1 and "Unpivot Other Columns" (Doing it this way will allow the column count to increase or decrease without having to amend the code)

#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Promoted Headers", {"RWIC "}, "Date", "Value"),

Select the "Date" column and Parse the date

#"Parsed Date" = Table.TransformColumns(#"Unpivoted Other Columns",{{"Date", each Date.From(DateTimeZone.From(_)), type date}}),

Now select the "Value" column and Split by Delimiter ("-")

#"Split Column by Delimiter" = Table.SplitColumn(#"Parsed Date", "Value", Splitter.SplitTextByDelimiter("-", QuoteStyle.Csv), {"Client", "Project", "Work Order", "Location"}),

Now we select the "Location" column and Split by Delimiter - (space " ")

#"Split Column by Delimiter1" = Table.SplitColumn(#"Split Column by Delimiter", "Location", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, true), {"Location", "Project Number"}),

Add a Custom Column that looks for PTO in the Client column

#"Added Custom" = Table.AddColumn(#"Split Column by Delimiter1", "isPTO", each if Text.Contains(Text.Upper([Client]), "PTO") then "PTO" else null),

Repeat this step for "Off" values

#"Added Custom1" = Table.AddColumn(#"Added Custom", "isOFF", each if Text.Contains(Text.Upper([Client]), "OFF") then "OFF" else null),

 Now we will replace the PTO values from the Client column with null

#"Replaced Value" = Table.ReplaceValue(#"Added Custom1","PTO",null,Replacer.ReplaceValue,{"Client"}),

And the Off values from the Client column with null

#"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","OFF",null,Replacer.ReplaceValue,{"Client"})

You should now have...

Hopefully this helps get your data transformed. 
If you are still having concerns, feel free to private message me and I would be happy to help from there.

Cheers.