You can split the cells in a column into rows if the cells contain multiple values delimited by a separator. Similarly, you can merge multiple cells into a row.
On the project data page, click the header of the column containing the values that you want to edit, click
Edit cells, and then click:
- Split multi-valued cells into rows to split cells into rows.
- Join rows into multi-valued cells to merge similar rows to cells containing multiple values.
For example, there is a project containing the candidate information for a job. The Phone column contains two phone numbers.
To split the cell values to rows:
- From the Phone column menu, click
.
- In the
Split column by field, enter a comma (,).
- Click
OK.
As shown, each cell value in the Phone column are split into two rows.
