Forum Discussion
Solved
Dynamic 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
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
Hello
How to start this repetition from the second element of the column and not from the first?
Thanks.