Forum Discussion
How to Delete Duplicate Cells per Row
An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
- Oh this seems to do the job, thank you so much! Would you mind explaining how you built it? I would love to be able to utilize this going forward.
Thanks again!You can start the Power Query Editor as shown in the screenshot. Power Query -> Editor starten (start editor in english Excel).
In the Power Query Editor you can follow the steps starting with "Quelle" or "source" in english. You can select any step you want. Currently the step "Quelle" (source) is selected. All the buttons and applied steps are shown in your language when you open the file. On the right side i've indicated the gear icons with blue dashes. You can click on a gear icon to view which rule has been applied to create the change of the data.
- Ohh I understand, thank you so so much for the help!! I will take a look at those steps and try to duplicate from the start with a new sheet.
I hope you have a great rest of your day! 😄
