Hi Negi :-)
Here is another one code for your text file... (not better, just different than Gil's code).
I think, there are all information you need.
let
Source = Table.FromColumns({Lines.FromBinary(File.Contents("C:\Users\Zbigniew\Downloads\Z pendrive\MPA Text file.txt"),null,null,1252)}),
AddColumn1 = Table.AddColumn(Source, "PE IP", each if Text.Contains([Column1], "]$ssh ") then [Column1] else null),
SplitCol1 = Table.SplitColumn(AddColumn1,"PE IP",Splitter.SplitTextByEachDelimiter({" "}, null, true),{"Custom.1", "PE IP"}),
ChType1 = Table.TransformColumnTypes(SplitCol1,{{"Custom.1", type text}, {"PE IP", type text}}),
RemoveCol1 = Table.RemoveColumns(ChType1,{"Custom.1"}),
AddColumn2 = Table.AddColumn(RemoveCol1, "PE", each if Text.Contains([Column1],"dis mac-address dynamic verbose") then Text.Start([Column1],Text.PositionOf([Column1],">")) else null),
ChType2 = Table.TransformColumnTypes(AddColumn2,{{"PE", type text}}),
PeplaceVal1 = Table.ReplaceValue(ChType2,"<","",Replacer.ReplaceText,{"PE"}),
AddColumn3 = Table.AddColumn(PeplaceVal1, "Slot", each if Text.StartsWith([Column1],"MAC address table of slot ") then Text.Replace([Column1], "MAC address table of slot ","") else null),
ChType3 = Table.TransformColumnTypes(AddColumn3,{{"Slot", type text}}),
ReplaceVal2 = Table.ReplaceValue(ChType3,":","",Replacer.ReplaceText,{"Slot"}),
FillDown1 = Table.FillDown(ReplaceVal2,{"PE IP", "PE", "Slot"}),
AddCol4 = Table.AddColumn(FillDown1, "Custom", each if Text.StartsWith([Column1],"MAC Address:") or Text.StartsWith([Column1],"Port :") or Text.StartsWith([Column1],"PEVLAN :") or Text.StartsWith([Column1],"TrustFlag :") or Text.StartsWith([Column1],"Peer IP :") or Text.StartsWith([Column1],"Aging time :") or Text.StartsWith([Column1],"TimeStamp :") or [Column1]="" then 1 else null),
FilterRows1 = Table.SelectRows(AddCol4, each ([Custom] = 1)),
SplitCol2 = Table.SplitColumn(FilterRows1,"Column1",Splitter.SplitTextByDelimiter(":"),{"Column1.1", "Column1.2", "Column1.3"}),
ChType4 = Table.TransformColumnTypes(SplitCol2,{{"Column1.1", type text}, {"Column1.2", type text}, {"Column1.3", type text}}),
TrimText1 = Table.TransformColumns(ChType4,{{"Column1.1", Text.Trim}, {"Column1.2", Text.Trim}, {"Column1.3", Text.Trim}}),
SplitCol3 = Table.SplitColumn(TrimText1,"Column1.2",Splitter.SplitTextByEachDelimiter({" "}, null, false),{"Column1.2.1", "Column1.2.2"}),
ChType5 = Table.TransformColumnTypes(SplitCol3,{{"Column1.2.1", type text}, {"Column1.2.2", type text}}),
TrimText2 = Table.TransformColumns(ChType5,{{"Column1.2.1", Text.Trim}, {"Column1.2.2", Text.Trim}}),
ReplaceVal3 = Table.ReplaceValue(TrimText2,null,"ToRemove",Replacer.ReplaceValue,{"Column1.2.2", "Column1.3"}),
ListColNam = List.Buffer({"MAC Address","VLAN/VSI/SI","Port","Type","PEVLAN","CEVLAN","TrustFlag","TrustPort","Peer IP","VC-ID","Aging time","LSP/MAC_Tunnel","TimeStamp"}),
ListColVal = List.Buffer( List.Repeat({"---"},13)),
AddCol5 = Table.AddColumn(ReplaceVal3, "Rec", each if [Column1.1] = "" then Record.FromList(ListColVal,ListColNam) else Record.FromList({[Column1.2.1],[Column1.3]},{[Column1.1],[Column1.2.2]})),
RemCol2 = Table.RemoveColumns(AddCol5,{"Column1.1", "Column1.2.1", "Column1.2.2", "Column1.3", "Custom"}),
ExpRec = Table.ExpandRecordColumn(RemCol2, "Rec", {"MAC Address", "VLAN/VSI/SI", "Port", "Type", "PEVLAN", "CEVLAN", "TrustFlag", "TrustPort", "Peer IP", "VC-ID", "Aging time", "LSP/MAC_Tunnel", "TimeStamp", "ToRemove"}, {"MAC Address", "VLAN/VSI/SI", "Port", "Type", "PEVLAN", "CEVLAN", "TrustFlag", "TrustPort", "Peer IP", "VC-ID", "Aging time", "LSP/MAC_Tunnel", "TimeStamp", "ToRemove"}),
AddCol6 = Table.AddColumn(ExpRec, "Mod", each if [MAC Address]<>null and [MAC Address] <> "---" then 1 else null),
FillUp1 = Table.FillUp(AddCol6,{"MAC Address", "VLAN/VSI/SI", "Port", "Type", "PEVLAN", "CEVLAN", "TrustFlag", "TrustPort", "Peer IP", "VC-ID", "Aging time", "LSP/MAC_Tunnel", "TimeStamp", "ToRemove"}),
FilterRows2 = Table.SelectRows(FillUp1, each ([Mod] = 1)),
RemCol3 = Table.RemoveColumns(FilterRows2,{"ToRemove", "Mod"}),
ChType6 = Table.TransformColumnTypes(RemCol3,{{"TimeStamp", type text}, {"LSP/MAC_Tunnel", type text}, {"Aging time", type text}, {"VC-ID", type text}, {"Peer IP", type text}, {"TrustPort", type text}, {"TrustFlag", type text}, {"CEVLAN", type text}, {"PEVLAN", type text}, {"Type", type text}, {"Port", type text}, {"VLAN/VSI/SI", type text}, {"MAC Address", type text}, {"Slot", type text}, {"PE", type text}, {"PE IP", type text}}),
ReplaceVal4 = Table.ReplaceValue(ChType6,"---","",Replacer.ReplaceText,{"TrustFlag", "TrustPort", "Peer IP", "VC-ID", "TimeStamp"})
in
ReplaceVal4
Regards :-)