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....
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!!
Hello Anonymous
WIll a project id have multiple task id?
Thanks,
Naveen