Concat Rows

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Concat Rows

Description

Concatenate multiple consecutive rows into a single row.

 

Example

Concatenate every 2 rows to 1:

 

how to concatenate 2 rows example

 

Inputs

One.

 

Options

Set Create 1 row from every to N to concatenate every N rows into 1 row.

 

Notes

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.

 

See also

Spread

Concat Cols