Concat Rows

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Concat Rows

Description

Concatenate multiple consecutive rows into a single row.

 

Example

Concatenating this dataset:

 

concat-rows-example-1

 

Every 2 rows:

 

concat-rows-example-2-win

 

Gives:

 

concat-rows-example-3

 

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