Changing data from imported websites

Juri_Messenboeck 

And there is much easier solution - instead of using default US region in URL like for Berlin

https://weather.com/weather/tenday/l/Berlin+Germany?canonicalCityId=49875d033efa3f8a515cc07b7ab1897df30ce65616175ffb4591cb95c5f646ff

use the link with your preferable region/language, e.g. UK/English URL for the Berlin will be

https://weather.com/en-UK/weather/tenday/l/5ca23443513a0fdc1d37ae2ffaf5586162c6fe592a66acc9320a0d0536be1bb9

(region code after weather.com/).

Result will be in units for this region. I have no idea why km/h is default for UK and why US and UK forecast for Berlin are bit different. Script is simple then

let
    Source = Web.Page(Web.Contents("https://weather.com/en-UK/weather/tenday/l/5ca23443513a0fdc1d37ae2ffaf5586162c6fe592a66acc9320a0d0536be1bb9")),
    Data0 = Source{0}[Data],
    ColumnNames=List.FirstN(Table.ColumnNames(Data0),6),
    RemoveDayColumn = Table.RemoveColumns(Data0,{"Day"}),
    TempColumnNames = Table.ColumnNames(RemoveDayColumn),
    ListOfList = List.Zip({TempColumnNames,ColumnNames}),
    RenameTableColumns = Table.RenameColumns(RemoveDayColumn, ListOfList),
    DayInOneString = Table.ReplaceValue(
        RenameTableColumns,
        "#(cr)#(lf)",
        " ",
        Replacer.ReplaceText,{"Day"}
    )
in
    DayInOneString

See in second sheet for Berlin attached.