How to merge lines with the same section in a CSV file

Problem

The table repeats the section several times. You need to leave one line per section and collect the values ​​separated by semicolons.

Short answer

Configure grouping of rows by key column and combining values in the summary column through the selected separator.

Sample task

The data below is educational. They show the conversion form, not the users' actual files.

It was

section,value
Section A,Value 1
Section A,Value 2
Section B,Value 3

It became

section,values
Section A,Value 1; Value 2
Section B,Value 3

How to set up

1. Upload CSV or XLSX as a table source.
2. Open the table editor and check that the column headings are recognized correctly.
3. In the settings of the desired column, open the block "Transformations".
4. If the entire line must be excluded, set the rule in a block "Unloading conditions".
5. Save the settings and download the result in the desired format.