Description
Split each row into multiple rows.
Example
Splitting these rows:
Before each column containing 'title':
Gives:
Inputs
One.
Options
•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 at 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.
•Split automatically:
oFind the first column name that appears more than once and split each row before each column with that name.
Notes
•Splits added before the first column are ignored, as there is already a split there.
•Use New Col or Rename Cols if you need to add additional columns or rename columns before splitting rows.
•The opposite of Split Rows is Concat Rows.