Forum Discussion
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. 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
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!!
5 Replies
- 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 Try this. In Power Query right click over the Task ID column header and Fill then Down
Hello Anonymous
WIll a project id have multiple task id?Thanks,
Naveen
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!!
