none
Fill Up blank spaces based on the cell above RRS feed

  • Question

  • Hi : Currently I perform fill up or fill down in Power Query due to large data size, it takes a lot of time to perform the action. What is the best way to fill blank spaces based on the cell above  for the column "Increm". But before performing the fill down, the data needs to be sorted by "Emp_No" in ASC followed by "Txn_Type" in DESC order. Just wondering what would be the select statement for filling down blank spaces based on the cell above. Thanking you in advance.

    https://1drv.ms/t/s!Amc8fiGpDxekh2B16Q5B-WWqV7Y2?e=gvAr6f

    Monday, December 23, 2019 2:05 AM