Split into several rows

[John Otto Knoke]

Hello Refiners,

I have a column that has several rows, each row has several values that I need to split in the same column.

Example:

Name   Options

John    apple, orange, strawberry

Need:

Name  Options

John   apple

John   orange

John   strawberry

Thanks,

[Thad Guidry]

Use Records mode

Use Edit Column -> Split multi-value cells

Use Blank down on Name column

-Thad

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Ettore Rizza]

Like this :

[Martin Magdinier]

agree with Thad however be mindful when using the blank down. if you have a blank name in your set. You can read more about it here: http://kb.refinepro.com/2012/03/fill-down-right-and-secure-way.html

[John Otto Knoke]

Thanks for the help Thad, my mistake was not selecting the Record mode.

On Wed, Dec 7, 2016 at 12:51 PM, Thad Guidry <thadg...@gmail.com> wrote:

Use Records mode

Use Edit Column -> Split multi-value cells

Use Blank down on Name column

-Thad

On Wed, Dec 7, 2016 at 11:45 AM John Otto Knoke <okn...@gmail.com> wrote:

Hello Refiners,

I have a column that has several rows, each row has several values that I need to split in the same column.

Example:

Name   Options

John    apple, orange, strawberry

Need:

Name  Options

John   apple

John   orange

John   strawberry

Thanks,

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.

To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google Groups "OpenRefine" group.

To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+unsubscribe@googlegroups.com.

[John Otto Knoke]

Thanks Ettore for taking the time to do the GIFF...........

--

[John Otto Knoke]

Thanks Martin, I was missing to select the record mode

On Wed, Dec 7, 2016 at 1:09 PM, Martin Magdinier <martin.m...@gmail.com> wrote:

agree with Thad however be mindful when using the blank down. if you have a blank name in your set. You can read more about it here: http://kb.refinepro.com/2012/03/fill-down-right-and-secure-way.html

On 16-12-07 01:51 PM, Thad Guidry wrote:

Use Records mode

Use Edit Column -> Split multi-value cells

Use Blank down on Name column

-Thad

On Wed, Dec 7, 2016 at 11:45 AM John Otto Knoke <okn...@gmail.com> wrote:

Hello Refiners,

I have a column that has several rows, each row has several values that I need to split in the same column.

Example:

Name   Options

John    apple, orange, strawberry

Need:

Name  Options

John   apple

John   orange

John   strawberry

Thanks,

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.

To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.

To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.

To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+unsubscribe@googlegroups.com.