Navigation: Reference > Transforms >
Concatenate multiple consecutive rows into a single row.
Concatenate every 2 rows to 1:
•Set Create 1 row from every to N to concatenate every N rows into 1 row.
•Use New Col if you need to add additional columns before concatenating rows.
•Use Filter if you need to remove rows before concatenating row.
•Use Rename Cols if you need to change column names after concatenating rows.
•The opposite of Concat Rows is Split Rows.