Copy a cell from a row and copy into another row

[goyalsa]

I am trying to copy the Product into the blank cell related to that product. For example, Product 1 under the product column for remark B and C.

The final result be like:

Any help would be appreciated!

[PijushRoy]

Hi @goyalsa 

Is your question resolved? 

If not. please let me posted
If solve, please mark as solution

[PijushRoy · Accepted solution]

HI @goyalsa 

Please use fill down option in power query
https://learn.microsoft.com/en-us/power-query/fill-values-column


If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS

Thanks
Pijush

[goyalsa]

Thanks Pijush!