# Split cells

**URL:** <https://forum.knime.com/t/split-cells/10261>\
**Category:** KNIME Analytics Platform\
**Created:** [March 7, 2018, 2:01pm UTC](https://forum.knime.com/t/split-cells/10261 "2018-03-07T14:01:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![hoppel77](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/h/97f17d/32.png) [@hoppel77](https://forum.knime.com/u/hoppel77)\
**Post date:** [March 7, 2018, 2:01pm UTC](https://forum.knime.com/t/split-cells/10261/1 "2018-03-07T14:01:11Z")

</div>

Hello,

I have a question on how to split string cells in Knime.

The following rows and columns are examples of how the dataset I use looks like:

Name Friends Street  
Peter [‘Alfred’, ‘George’, ‘Paul’] Lakeview  
Molly [‘Mike’, ‘John’] Seaside  
Jason [‘Fred’] King  
Ashley [‘Jessica’, ‘Brad’, ‘Justin’] Westside

As a result the second column “Friends” needs to be split into three columns as followed:

Name Friend1 Friend2 Friend3 Street  
Peter Alfred George Paul Lakeview  
Molly Mike John Seaside  
Jason Fred King  
Ashley Jessica Brad Justin Westside

How can I do this?

Thank you!

hoppel77

---

<div class="post-metadata">

**Author:** ![s.roughley](https://forum-cdn.knime.com/user_avatar/forum.knime.com/s.roughley/32/366_2.png) [@s.roughley](https://forum.knime.com/u/s.roughley)\
**Post date:** [March 7, 2018, 4:12pm UTC](https://forum.knime.com/t/split-cells/10261/2 "2018-03-07T16:12:56Z")

</div>

If the Friends column is a collection column then you need a `Split Collection Column` node. If it is a single text cell, then a `Cell Splitter` node should cover it

Steve

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [June 23, 2023, 8:28pm UTC](https://forum.knime.com/t/split-cells/10261/3 "2023-06-23T20:28:39Z")

</div>


