# Coverting Cell to Separate Columns

**URL:** <https://community.easymorph.com/t/coverting-cell-to-separate-columns/1869>\
**Category:** General Q&A\
**Created:** [May 26, 2020, 10:30am UTC](https://community.easymorph.com/t/coverting-cell-to-separate-columns/1869 "2020-05-26T10:30:58Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![seo.goo.kang](https://community.easymorph.com/letter_avatar_proxy/v4/letter/s/48db29/32.png) [@seo.goo.kang](https://community.easymorph.com/u/seo.goo.kang)\
**Post date:** [May 26, 2020, 10:30am UTC](https://community.easymorph.com/t/coverting-cell-to-separate-columns/1869/1 "2020-05-26T10:30:59Z")

</div>

```
Thanks for your support as always.

I have a list of cells as below. I want this to be separate two columns like below.

Can Easymorph help this?

[example]
-------------------------------------------
| Success Rate [%] = A / B * 100 |
| . A = FAMILYID101:ConnEstabSucc |
| . B = FAMILYID2211:ConnEstabAtt |
--------------------------------------------

```

We have to refer to a formula 'A / B \*100' each cell.

```
[To be columns]
--------------------------------------------------------------------------------------
| Name | Formula |
---------------------------------------------------------------------------------------
| Success Rate [%] | sum(ConnEstabSucc)/sum(ConnEstabAtt) *100 |
---------------------------------------------------------------------------------------

Thank you.

```

---

<div class="post-metadata">

**Author:** ![andrew.rybka](https://community.easymorph.com/user_avatar/community.easymorph.com/andrew.rybka/32/13_2.png) [@andrew.rybka](https://community.easymorph.com/u/andrew.rybka)\
**Post date:** [May 26, 2020, 12:58pm UTC](https://community.easymorph.com/t/coverting-cell-to-separate-columns/1869/2 "2020-05-26T12:58:26Z")

</div>

Hi Seogoo,

So you need to split `Success Rate [%] = A / B * 100` to two different columns with values `Success Rate [%]` and `A / B * 100` and then substitute A and B with their values?

Can you please elaborate on variable conversion rules? For example, it's not clear for me how `FAMILYID101:ConnEstabSucc` was converted to `sum(ConnEstabSucc)`.

Also, can you please provide more examples.

---

<div class="post-metadata">

**Author:** ![seo.goo.kang](https://community.easymorph.com/letter_avatar_proxy/v4/letter/s/48db29/32.png) [@seo.goo.kang](https://community.easymorph.com/u/seo.goo.kang)\
**Post date:** [May 27, 2020, 12:42am UTC](https://community.easymorph.com/t/coverting-cell-to-separate-columns/1869/3 "2020-05-27T00:42:51Z")

</div>

Thank you for your response.

Let me elaborate little bit more.

Logic

1. FAMILYID101: -\> I need to delete this part, you may use keepbefore ":"
2. ConnEstaSucc -\> I want to keep this part adding sum() just like sum(ConnEstaSucc)

Those two parts are changes along with rows

Feel free to ask again.

Thank you.

---

<div class="post-metadata">

**Author:** ![andrew.rybka](https://community.easymorph.com/user_avatar/community.easymorph.com/andrew.rybka/32/13_2.png) [@andrew.rybka](https://community.easymorph.com/u/andrew.rybka)\
**Post date:** [May 27, 2020, 11:57am UTC](https://community.easymorph.com/t/coverting-cell-to-separate-columns/1869/4 "2020-05-27T11:57:14Z")

</div>

Seogoo, does the formulas always have only two arguments which are named A and B?

---

<div class="post-metadata">

**Author:** ![seo.goo.kang](https://community.easymorph.com/letter_avatar_proxy/v4/letter/s/48db29/32.png) [@seo.goo.kang](https://community.easymorph.com/u/seo.goo.kang)\
**Post date:** [May 28, 2020, 2:03am UTC](https://community.easymorph.com/t/coverting-cell-to-separate-columns/1869/5 "2020-05-28T02:03:39Z")

</div>

yes, just A and B.

---

<div class="post-metadata">

**Author:** ![andrew.rybka](https://community.easymorph.com/user_avatar/community.easymorph.com/andrew.rybka/32/13_2.png) [@andrew.rybka](https://community.easymorph.com/u/andrew.rybka)\
**Post date:** [May 28, 2020, 8:46am UTC](https://community.easymorph.com/t/coverting-cell-to-separate-columns/1869/6 "2020-05-28T08:46:28Z")

</div>

Here is an example project:  
[Parse formula.morph](https://community.easymorph.com/uploads/short-url/ktZECKXUuEJAEq0fobEmmoXzsGu.morph) (5.3 KB)

Note that newline characters have to be replaced with some other character since newline characters can't be used as a separator in the "Split delimited text into columns" action.

---

<div class="post-metadata">

**Author:** ![seo.goo.kang](https://community.easymorph.com/letter_avatar_proxy/v4/letter/s/48db29/32.png) [@seo.goo.kang](https://community.easymorph.com/u/seo.goo.kang)\
**Post date:** [May 28, 2020, 10:41am UTC](https://community.easymorph.com/t/coverting-cell-to-separate-columns/1869/7 "2020-05-28T10:41:19Z")

</div>

Thank you Andrew, Understood how to do it.  
I will play around with it for more cases for my work.