let
Source = Excel.CurrentWorkbook(){[Name="表3"]}[Content],

"Changed Type" = Table.TransformColumnTypes(Source,{{"日期", type date}, {"id", type text}, {"金额", Int64.Type}, {"销量", Int64.Type}}),

#"Unpivoted Only Selected Columns" = Table.Unpivot(#"Changed Type", {"金额", "销量"}, "属性", "值"),
#"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Unpivoted Only Selected Columns", {{"日期", type text}}, "zh-CN"),{"日期", "属性"},Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"已合并"),
#"Pivoted Column" = Table.Pivot(#"Merged Columns", List.Distinct(#"Merged Columns"[已合并]), "已合并", "值"),
#"Reordered Columns" = Table.ReorderColumns(#"Pivoted Column",{"id", "2019/6/5 金额", "2019/6/6 金额", "2019/6/7 金额", "2019/6/5 销量", "2019/6/6 销量", "2019/6/7 销量"})

in

"Reordered Columns"

可以试试通过添加列
名字列 = Table.AddColumn(更改的类型1, "名字列", each Text.Remove([样例.4],{"0".."9","."})),
数字列 = Table.AddColumn(名字列, "数字列", each Text.Remove([样例.4],{"一".."龟"}))
in
数字列

每日更新的数据最好是在数据原始表上更新，Power Query 从数据源表上获取，Power Query 运行的数据导出到另外的table 即可