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.
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! 😄You are welcome. I've just noticed that you work with Office 365. An alternative to Power Query could be a dynamic arrayformula. I hope you have a great rest of your day as well!
=LET(unique,BYROW(B2:E10,LAMBDA(row,TEXTJOIN(",",,TOROW(UNIQUE(TRANSPOSE(row)))))),HSTACK(A2:A10,IFNA(DROP(REDUCE("",unique,LAMBDA(ini,arr,VSTACK(ini,TEXTSPLIT(arr,",")))),1),"")))😄
