Navigation: Reference > Transforms >
Split each row into multiple rows.
Splitting these rows:
Before each column containing 'title':
•Split by column name:
oEach row will be split before each column that matches the criteria. The matching is sensitive to case and whitespace.
•Split a fixed number of times:
oDefine the number of times you want to split each row, starting before which column and then every N columns.
oThe split is added before the designated columns.
oSplits after the last column are ignored. So you can set times to a large number if you don't know how many columns there will be.
oFind the first column name that appears more than once and split each row before each column with that name.
•Splits added before the first column are ignored, as there is already a split there.
•The opposite of Split Rows is Concat Rows.