多个相同值逐个替换成不同值

wgm107

小弟初识PowerQuery，有个问题想请教。
如果有一个列表中，相同的数据包含多个，想每个都替换不同的，该怎么做呢？例如:
={10,20,null,30,40,50,null,15,25,35,null,11,22,33,44,null}。
有4个null，按照
={30,120,75,110}
一个一个的来完成对应的替换，变成
={10,20,30,30,40,50,120,15,25,35,75,11,22,33,44,110}
该怎么做呀？？非常感谢！！

minchar

= List.Accumulate(List.PositionOf({10,20,null,30,40,50,null,15,25,35,null,11,22,33,44,null},null,2),{10,20,null,30,40,50,null,15,25,35,null,11,22,33,44,null},(x,y)=> List.ReplaceRange(x,y,1,{{30,120,75,110}{4-List.Count(x)+List.NonNullCount(x)}}))

zjnfxxh

....................................

ThxAlot

1. let
   
2.     Source = {10,20,null,30,40,50,null,15,25,35,null,11,22,33,44,null},
   
3.     Replaced = List.Accumulate(List.Zip({List.PositionOf(Source, null, Occurrence.All),{30,120,75,110}}), Source, (s,c) => List.ReplaceRange(s,c{0},1,{c{1}}))
   
4. in
   
5.     Replaced

复制代码

quqiyuan

1. 发错。。。

复制代码

maoxiong1999

let
    源 = {10,20,null,30,40,50,null,15,25,35,null,11,22,33,44,null},
    a = {30,120,75,110},
    b = List.Accumulate(List.Zip({List.PositionOf(源,null,2),a}),源,
        (x,y)=>List.ReplaceRange(x,y{0},1,{y{1}}))
in
    b

飞天篮球猪