请教大神怎么实现这样的效果
请教大神怎么实现这样的效果
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"
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"