let
source = Web.Contents("https://www.planetaexcel.ru/forum/"),
toText = Text.FromBinary(source),
xhtml = Text.Replace("<table>" & Text.BetweenDelimiters(toText, "<table cellspacing=""0"" class=""forum-table forum-forum-list"">", "</table>") & "</table>", "<br>", ""),
xhtml2 = Text.Replace(xhtml, " ", ""),
toXml = Xml.Document(xhtml2),
tbody = toXml{0}[Value]{1}[Value][[Value]],
#"Expanded {0}" = Table.ExpandTableColumn(tbody, "Value", {"Value"}, {"Value.1"}),
#"Expanded {0}1" = Table.ExpandTableColumn(#"Expanded {0}", "Value.1", {"Value"}, {"Value"}),
tableOnly = Table.SelectRows(#"Expanded {0}1", each [Value] is table),
#"Expanded {0}2" = Table.ExpandTableColumn(tableOnly, "Value", {"Name", "Value", "Attributes"}),
#"Expanded {0}3" = Table.ExpandTableColumn(#"Expanded {0}2", "Attributes", {"Value"}, {"Value.1"}),
#"Filtered Rows" = Table.SelectRows(#"Expanded {0}3", each ([Value.1] = "forum-item-name")),
#"Expanded {0}4" = Table.ExpandTableColumn(#"Filtered Rows", "Value", {"Value", "Attributes"}, {"Value.2", "Attributes"}),
#"Removed Columns" = Table.RemoveColumns(#"Expanded {0}4",{"Name", "Attributes", "Value.1"}),
#"Expanded {0}5" = Table.ExpandTableColumn(#"Removed Columns", "Value.2", {"Value", "Attributes"}, {"Value", "Attributes"}),
nameAndLinks = Table.ExpandTableColumn(#"Expanded {0}5", "Attributes", {"Value"}, {"ahref"}),
addFormula = Table.AddColumn(nameAndLinks, "href", each
"=HYPERLINK(""https://www.planetaexcel.ru" & [ahref] & """,""" & [Value] & """)"
)
in
addFormula[[href]] |