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
I did not get your answer.
I knew the reason, but I would like to understand how to fix the issue.
I am not so familiar with PQ unfortunately. 🙂
Thanks a lot.