Hello! I’d like to ask for help in following problem.
I have an Excel file with multiple columns which I need to filter in a specific way. What I want to achieve is to keep only these rows which have the same values in selected columns.
From the table above I need to drag out these rows where values for first 4 columns are the same. In this example the proper result would be 2 sets of data:
I tried to create DTs for each column, then clean it from duplicates and then use it in a ‘for each row’ for each of the column which I need to filter. Unfortunately, nesting it one in another doesnt work for more than 2 columns (my code in attachment)
. I’m sure there must be another way - please help