Creating function to repeat Power Query steps

[lastnn30]

Hi
Is it possible to create a function that would repeat Power Query steps? For example if I used Power Query to split a column then I want to repeat these steps on different table; hence I need to create a function that would repeat these steps. Is that possible? I did not do my search but I thought I would start here first. Thank you very much.

[sandy666]

adapt this to your needs

let
  Source = Excel.CurrentWorkbook(){[Name = "Table1"]}[Content],
  Result = List.Accumulate(
    Table.ColumnNames(Source), 
    Source, 
    (st, cur) => 
      if List.AnyTrue(List.Transform(Table.Column(st, cur), each Text.Contains(_, "|")))
      then Table.SplitColumn(st, cur, Splitter.SplitTextByDelimiter("|", QuoteStyle.Csv), 2)
      else st
  )
in
  Result

you can change pipe "|" to any other delimiter