Forum Discussion
Formula for copying down formula in specific order
excel_learner Include the Index column in your sort. First by Week no then by Index. But, perhaps, difficult to judge from screenshots alone.
excel_learner Similar to this, I guess:
https://techcommunity.microsoft.com/t5/excel/copying-down-rows/m-p/2959533
The issue I'm having with how the budget forecast and actuals are laid out in power query I want to have it laid it out as " budge, forecast, Actuals"
like this below
but when I sort the customer column (week no) it becomes like this the BFA column is not in the correct order. is there a way to get in the correct order of Budget then forecast then actuals whilst having the week no sorted ascending.
excel_learner Include the Index column in your sort. First by Week no then by Index. But, perhaps, difficult to judge from screenshots alone.