Forum Discussion
Mic1979
Post Partisan
Post PartisanDynamic List.Repeat
Dear all, I have the following set of data: I used the following formula to get: ColToMove = HeadersToShift, MovedCol = List.Repeat({null},2)&ColToMove I tried to make th...
because Rows_To_ShiftDown is a table, not a single number — but List.Repeat expects a number as its second argument (how many times to repeat).
maybe you can use the following formula instead
ShiftCount = Rows_To_ShiftDown{0}[YourColumnName],
MovedCol = List.Repeat({null}, ShiftCount) & ColToMove
v-kathullac
Community Support
Community SupportHi Mic1979 ,
we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Regards,
Chaithanya
Mic1979Post Partisan
Post PartisanHello v-kathullac
sorry for the delay, I just had the opportunity to test the solution.
Accepted, many thanks for your great support.