# Merge Values with new line character

**URL:** <https://community.parabola.io/t/merge-values-with-new-line-character/1172>\
**Category:** Ask a question\
**Tags:** Building-Flows\
**Created:** [October 14, 2020, 6:17am UTC](https://community.parabola.io/t/merge-values-with-new-line-character/1172 "2020-10-14T06:17:33Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sam\_Henry](https://avatars.discourse-cdn.com/v4/letter/s/f0a364/32.png) [@Sam\_Henry](https://community.parabola.io/u/Sam_Henry)\
**Post date:** [October 14, 2020, 6:17am UTC](https://community.parabola.io/t/merge-values-with-new-line-character/1172/1 "2020-10-14T06:17:33Z")

</div>

Hey All,

Im needing to merge a bunch of rows with a new line character, is there a way to do that?

Thanks

---

<div class="post-metadata">

**Author:** ![anon36387498](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@anon36387498](https://community.parabola.io/u/anon36387498)\
**Post date:** [October 14, 2020, 5:16pm UTC](https://community.parabola.io/t/merge-values-with-new-line-character/1172/2 "2020-10-14T17:16:52Z")

</div>

Hi @Sam_Henry,

Currently we don’t support this use case, though it is on our roadmap to be added soon. We’ll be sure to update this thread once it is out. Thanks!

---

<div class="post-metadata">

**Author:** ![KLoic](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/kloic/32/1355_2.png) [@KLoic](https://community.parabola.io/u/KLoic)\
**Post date:** [September 8, 2021, 1:04pm UTC](https://community.parabola.io/t/merge-values-with-new-line-character/1172/3 "2021-09-08T13:04:41Z")

</div>

Hi @anon36387498 , has this use case been added to your product yet???

---

<div class="post-metadata">

**Author:** ![Adam\_R](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/adam_r/32/2207_2.png) [@Adam\_R](https://community.parabola.io/u/Adam_R)\
**Post date:** [September 8, 2021, 5:09pm UTC](https://community.parabola.io/t/merge-values-with-new-line-character/1172/4 "2021-09-08T17:09:35Z")

</div>

Hi @KLoic and @Sam_Henry,

This sounds like it should be possible with our “Merge Duplicate Rows” step. If you’d like to merge all rows into 1 row with a new line character as the delimiter, you can first insert a new text column with a static value so that you have a column to merge the data on.

 ![Screen Shot 2021-09-08 at 9.55.08 AM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/f/fc05520027b209962c48cbe46bb139a74a22b9a9.jpeg)

 ![Screen Shot 2021-09-08 at 9.55.28 AM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/8/8fdbc9f6223a5407adb5b93f44b2b5dbbd0aea99.png)

If you want to add some logic to the merging, you can also use the “If/ Else” step to group the merging using rules.

Once you have your column containing values to merge on, you can combine the rows using the “Merge Duplicate Rows” step, using your new line character as the delimiter:

 ![Screen Shot 2021-09-08 at 10.07.17 AM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/0/08508c5347634dc9929bbc23d11d554307594014.jpeg)

 ![Screen Shot 2021-09-08 at 10.08.40 AM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/c/c9658f8c581ad61675ed4e3576af8380e926d6c0.jpeg)

Let me know if this solves the use case that you’re working on!

---

<div class="post-metadata">

**Author:** ![KLoic](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/kloic/32/1355_2.png) [@KLoic](https://community.parabola.io/u/KLoic)\
**Post date:** [September 8, 2021, 10:03pm UTC](https://community.parabola.io/t/merge-values-with-new-line-character/1172/5 "2021-09-08T22:03:35Z")

</div>

Thank you for your quick reply @Adam_R , from results’ screenshot, it doesn’t look like the merged column display the merged values with a new ligne (one on top of the other).

Thanks

---

<div class="post-metadata">

**Author:** ![Adam\_R](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/adam_r/32/2207_2.png) [@Adam\_R](https://community.parabola.io/u/Adam_R)\
**Post date:** [September 8, 2021, 10:13pm UTC](https://community.parabola.io/t/merge-values-with-new-line-character/1172/6 "2021-09-08T22:13:49Z")

</div>

@KLoic No problem. My understanding was that you wanted to add a line break _character_, and then export the data to a data source where the line break character would actually cause the data to be on different lines. In Parabola, data will always be displayed on one line, and we do not have a ‘line break character’ of our own.

Where are you trying to export this data, and what exactly are you hoping to accomplish in your flow?

---

<div class="post-metadata">

**Author:** ![KLoic](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/kloic/32/1355_2.png) [@KLoic](https://community.parabola.io/u/KLoic)\
**Post date:** [September 8, 2021, 10:27pm UTC](https://community.parabola.io/t/merge-values-with-new-line-character/1172/7 "2021-09-08T22:27:20Z")

</div>

Ok gotcha… Thanks again.
