How To Combine Rows In Power Query

[Cheloo]

Moderator Note: Your opened Ask an Excel Question has moved to Correct Forum

Hello dear Experts,

I would like to use Power Query to transform Table 1 into Table 2. The goal is to combine the rows.

Note: The colors are for illustrative purposes only, so that you can better understand the transformation being performed.

I WISH IF I COULD HAVE A STEP BY STEP PROCESS IN POWERQUERY

THANKS

 

[AlanSidman]

crossposted: https://www.myonlinetraininghub.com/excel-forum/excel/how-to-combine-rows-in-power-query#p31192
which has a solution.

 

[vletm]

Cheloo​

Forum Rules are for everyone

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

 

[p45cal]

See PQ table at cell A25.
Similar to the solution at your cross-post but the text is more closed up in column Libellé de l'opération.

 

[Cheloo]

Cheloo​

Forum Rules are for everyone

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

I am very sorry for that, please forgive me. i have attached the solution received from crossposting

 

[Cheloo]

See PQ table at cell A25.
Similar to the solution at your cross-post but the text is more closed up in column Libellé de l'opération.

Thanks So much, I very happy to get the solution, could you please tell me the version of office used to do the job

 

[p45cal]

could you please tell me the version of office used to do the job

 

[AlanSidman]

Read my signature. Its there.