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

[Anonymous]

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 ID	Project ID	Expected Result
1239498	1022	1239498
	1022	1239498
1239498	1809	1239498
1239495	10566	1239495
1239446	1265	1239446
	1265	1239446
	1265	1239446

[Anonymous]

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 ID	Project ID	Expected Result
1239498	1022	1239498
	1022	1239498
1239498	1809	1239498
1239495	10566	1239495
1239446	1265	1239446
	1265	1239446
	1265	1239446

[RocketRod]

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

[Anonymous]

Muliptle same as shown but the same Project ID cannot have two different Task ID's

[NaveenGandhi · Accepted solution]

@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!!

[NaveenGandhi]

Hello @Anonymous 

WIll a project id have multiple task id?

Thanks,

Naveen