Splitting and Merging Cells

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 column that you want to edit cell values for and 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 project that contains the candidate information for a job. The Phone column contains two phone numbers.

To split the cell values to rows:

Click the Phone column and click Edit cells > Split Multi-valued cells into rows.
In the Split column by field, enter a comma (,).
Click OK.
As shown, the cell values in the Phone column are split to rows.