Once again, I want to express my gratitude to the developers for their excellent software.
I use EDT with great pleasure.
I am currently experiencing problems in solving the following task.
It is required to merge columns based on the principle of their complete coincidence.
Let me give you a table as an example. In the input information (columns B - K) there are repeated values. In the example, I gave ten columns, but there are more than twenty of them.
It is necessary to ignore repetitions in values and put unique values in a table with fewer columns.
The solution through the “If” function does not help, since there are quite a few columns.
The ideal solution would be to reduce the columns from 10 to 4, well, or from 20 to 5 for example.
What I would like to get as a result, displayed in the picture (out fragment). To simplify the work, the file is attached.
example article.transform (1.2 KB)