Power Query Question

Try this. (PBIX attached)

let
  Source = Excel.Workbook(
    File.Contents("H:\My Drive\Power BI\Community Solutions\Files\SecurityRole.xlsx"),
    null,
    true
  ),
  #"Removed Other Columns" = Table.SelectColumns(Source, {"Name", "Data"}),
  #"Renamed Columns" = Table.RenameColumns(#"Removed Other Columns", {{"Name", "Year"}}),
  #"Added Custom" = Table.AddColumn(#"Renamed Columns", "Custom", each Table.PromoteHeaders([Data])),
  #"Removed Columns" = Table.RemoveColumns(#"Added Custom", {"Data"}),
  #"Expanded Custom" = Table.ExpandTableColumn(
    #"Removed Columns",
    "Custom",
    {"Name ", "EmplID ", "Security role"},
    {"Name ", "EmplID ", "Security role"}
  ),
  #"Grouped Rows" = Table.Group(
    #"Expanded Custom",
    {"Year", "Name ", "EmplID "},
    {
      {"Count", each Table.RowCount(_), Int64.Type},
      {
        "all",
        each _,
        type table [Name = text, #"Name " = text, #"EmplID " = number, Security role = text]
      }
    }
  ),
  Concat = Table.AggregateTableColumn(
    #"Grouped Rows",
    "all",
    {
      {
        "Security role",
        each Text.Combine(List.Transform(_, (x) => Text.From(x)), ", "),
        "Security Role"
      }
    }
  ),
  #"Pivoted Column" = Table.Pivot(Concat, List.Distinct(Concat[Year]), "Year", "Security Role")
in
  #"Pivoted Column"