PQ多列一起转行

科科董

源数据


目标数据

请高手指教！！！

zpy2

https://club.excelhome.net/forum.php?mod=viewthread&tid=1653529&fromguid=hot&extra=&mobile&_dsign=be3646b2

静听溪流

问问题   最好上传个模拟数据附件

ThxAlot

静听溪流 发表于 2023-8-11 16:20
问问题   最好上传个模拟数据附件

再简化一些，而且不受原表表头变化影响。

1. let
   
2.     Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUfJKzNNxS03S8U0sAvIMDXSMDHSMDZRidaKVnFCldRwLIEpAakCKDHRMDCAqnYHiQFmgqkogy8TERMfU1FQpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Month = _t, Qty = _t]),
   
3. 
   
4.     #"Combined Columns" = Table.CombineColumns(
   
5.         Source,
   
6.         List.Skip(Table.ColumnNames(Source)),
   
7.         each Table.FromColumns(List.Transform(_, each Text.Split(_, ","))),
   
8.         "comb"),
   
9.     #"Expanded comb" = Table.ExpandTableColumn(#"Combined Columns", "comb", {"Column1", "Column2"}, {"Month", "Qty"})
   
10. in
    
11.     #"Expanded comb"

复制代码