let
    Source = Folder.Files("S:\ABC National Office\Accounting\A Documents\Projects\Bands Road\Revision March 2020\Info from Tina\Info from Amanda\Actual Rosters"),
    #"Filtered Hidden Files1" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true),
    #"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File", each #"Transform File"([Content])),
    #"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),
    #"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File"}),
    #"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File", Table.ColumnNames(#"Transform File"(#"Sample File"))),
    #"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"Source.Name", type text}, {"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", type text}, {"Column12", type text}, {"Column13", type text}, {"Column14", type text}, {"Column15", type text}, {"Column16", type any}, {"Column17", type any}, {"Column18", type any}, {"Column19", type any}, {"Column20", type any}, {"Column21", type any}, {"Column22", type any}}),
    #"Removed Blank Rows" = Table.SelectRows(#"Changed Type", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}))),
    #"Removed Top Rows" = Table.Skip(#"Removed Blank Rows",2),
    #"Removed Columns" = Table.RemoveColumns(#"Removed Top Rows",{"Column1"}),
    #"Transposed Table" = Table.Transpose(#"Removed Columns"),
    #"Filled Down Dates" = Table.FillDown(#"Transposed Table",{"Column1", "Column8", "Column17", "Column24"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Filled Down Dates",{{"Column1", type datetime}, {"Column8", type datetime}, {"Column17", type datetime}, {"Column24", type datetime}}),
    #"Table To Columns" = Table.ToColumns(#"Changed Type1"),
     #"Converted to Table" = Table.FromList(#"Table To Columns", Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Added Index" = Table.AddIndexColumn(#"Converted to Table", "Index", 0, 1),
    #"Added Custom" = Table.AddColumn(#"Added Index", "Custom", each [Column1]{0}),
     #"Added Index2" = Table.AddColumn(#"Added Custom", "Index2", each if [Custom] is datetime then [Index] else null),
    #"Filled Down" = Table.FillDown(#"Added Index2",{"Index2"}),
    //#"Updated Index" = Table.TransformColumns(#"Filled Down", {{"Index", each Number.IntegerDivide(_, 2), Int64.Type}}),
    #"Grouped Rows" = Table.Group(#"Filled Down", {"Index2"}, {{"Partition", each Table.FromColumns(_[Column1]), type table [Column1=list, Index=number]}}, GroupKind.Local),
    #"Combined Grouped Rows" = Table.Combine(#"Grouped Rows"[Partition]),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Combined Grouped Rows", {"Column1", "Column2"}, "Attribute", "Value"),
    #"Removed Other Columns2" = Table.SelectColumns(#"Unpivoted Other Columns",{"Column1", "Column2", "Value"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Other Columns2",{{"Column1", "Date"}, {"Column2", "In/Out"}, {"Value", "Name"}}),
    #"Change Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Date", type date}, {"In/Out", type text}, {"Name", type text}})
in
    #"Change Type"