Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Power Query to copy down Task ID value when Project ID values are consective

Hi Experts   Not sure on how to do the following step in Power Query, but i need to copy down the Task ID value where we have consective project id value.  See sample data with expected end result....
Need Help
  • NaveenGandhi's avatar
    NaveenGandhi
    3 years ago

    Anonymous 

    Create a copy of the table without the blanks as below.

    Then merge the original table and duplicated table based on project id and expand the task id as new column.

    If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago
 
Hi Experts

 

Not sure on how to do the following step in Power Query, but i need to copy down the Task ID value where we have consective project id value.  See sample data with expected end result. where the Project ID is not consective leave Task ID AS IS

Task IDProject IDExpected Result
123949810221239498
 10221239498
123949818091239498
1239495105661239495
123944612651239446
 12651239446
 12651239446
  • RocketRod's avatar
    RocketRod
    Frequent Visitor
    3 years ago

    Try this.  In Power Query right click over the Task ID column header and Fill then Down