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
The attached file contains a query that does what you ask for. In the Advanced editor you can follow the applied steps. Quite a few of them I'm afraid as I tried to keep it as straight forward as possible.
Come back here if you get stuck.
Thanks So much, I very happy to get the solution, it is ok now. Could you please tell me the version of office used to do the job. Deeply sorry for the cross posting.
I've used Excel MS365 Insider/Beta, version 2403 but the solution provided should work on older versions as well.
THANKS FOR YOUR FEEDBACK
