Folder Data Source and Pivot

Hi Garry,

yes, looking good in general. You bind it in like this (and add 2 additional steps): 

... your query up til here so far ...  
  #"Changed Type1" = Table.TransformColumnTypes(#"Renamed Columns",{{"Category", type text}}),
  //  #"Added Index" = Table.AddIndexColumn(#"Changed Type1", "Index", 1, 1),
Group = Table.Group(#"Changed Type1", {"Source.Name"}, {{"All", each Table.AddIndexColumn(_, "NestedIndex",1,1), type table}}),
Remove = Table.RemoveColumns(#"Grouped Rows",{"Source.Name"})
Expand = Table.ExpandTableColumn(Remove, "All", Table.ColumnNames(Remove[All]{0}), Table.ColumnNames(Remove[All]{0}))
    #"Pivoted Column" = Table.Pivot(Expand, List.Distinct(Expand[Category]), "Category", "Column1"),
    DataRaw = #"Pivoted Column"{0}[DataRaw]
in
    DataRaw

syntax might not be 100% correct, so pls come back with error-message if it fails :-)