# Join columns and unite the results in one line **URL:** \ **Category:** Ask for Help\ **Created:** [January 26, 2021, 11:41am UTC](https://community.glideapps.com/t/join-columns-and-unite-the-results-in-one-line/21746 "2021-01-26T11:41:09Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [January 26, 2021, 11:41am UTC](https://community.glideapps.com/t/join-columns-and-unite-the-results-in-one-line/21746/1 "2021-01-26T11:41:09Z")
I joined the columns content with sheets as I didn’t find a way to do it in glide, then I’d like to unite the results of that column into a single cell (join list), but I’d like to join them with a line break, how can I do it? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 26, 2021, 12:01pm UTC](https://community.glideapps.com/t/join-columns-and-unite-the-results-in-one-line/21746/2 "2021-01-26T12:01:39Z")
Sounds like you just need a template column to join multiple columns together. Then a Joined List column to join all those templates into one cell. You can set the delimiter in the joined list column to be a line break if that’s what you want, or make the line break part of your template column. ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [January 26, 2021, 1:01pm UTC](https://community.glideapps.com/t/join-columns-and-unite-the-results-in-one-line/21746/3 "2021-01-26T13:01:42Z")
Yes, but I wasn’t able to make them work, would you be so gentle to help me out? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 26, 2021, 1:59pm UTC](https://community.glideapps.com/t/join-columns-and-unite-the-results-in-one-line/21746/4 "2021-01-26T13:59:34Z")
Where did you get stuck? Do you have any screenshots? ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [January 26, 2021, 2:25pm UTC](https://community.glideapps.com/t/join-columns-and-unite-the-results-in-one-line/21746/5 "2021-01-26T14:25:54Z")
All of it, the entries are new rows created by the user ![Schermata del 2021-01-26 15-23-02](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/2/c283ce8b337d206786f1badacb2ecf9b01c7b4d2.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 26, 2021, 2:32pm UTC](https://community.glideapps.com/t/join-columns-and-unite-the-results-in-one-line/21746/6 "2021-01-26T14:32:01Z")
Just enter something like ‘A B C’ into the template. Then create replacements to replace A with Column1, B with Column2, and C with Column2. [https://docs.glideapps.com/all/reference/data-editor/computed-columns/template-column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/template-column) Then create a Joined List column that points to the template column. Set the delimiter bro something like `
` for your line break. Finally use that Joined List column as the source of a rich text component. ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [January 26, 2021, 2:55pm UTC](https://community.glideapps.com/t/join-columns-and-unite-the-results-in-one-line/21746/7 "2021-01-26T14:55:01Z")
Thank you, very kind and useful. Unfortunately I tried `
` but it doens’t work, it just gets copied as `
` ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 26, 2021, 3:08pm UTC](https://community.glideapps.com/t/join-columns-and-unite-the-results-in-one-line/21746/8 "2021-01-26T15:08:16Z")
Are you using it in a rich text component? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 26, 2021, 3:17pm UTC](https://community.glideapps.com/t/join-columns-and-unite-the-results-in-one-line/21746/9 "2021-01-26T15:17:44Z")
If you don’t need to use it in a rich text component, just press enter and it will create a new line for each joined entry. ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [January 26, 2021, 3:18pm UTC](https://community.glideapps.com/t/join-columns-and-unite-the-results-in-one-line/21746/10 "2021-01-26T15:18:10Z")
No, I wasn’t. Ok, I think I understand now, thx a lot again. I will send it in an automated email when the order is placed, it should show as new line I presume. I’ll test it, thanks again, very kind. > [@ThinhDinh](#): > > If you don’t need to use it in a rich text component, just press enter and it will create a new line for each joined entry. cool, useful too, thanks ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 26, 2021, 3:31pm UTC](https://community.glideapps.com/t/join-columns-and-unite-the-results-in-one-line/21746/11 "2021-01-26T15:31:23Z")
As @ThinhDinh pointed out with pressing Enter…sometimes I find that 2 spaces followed by the Enter key seems to work better to break lines. ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [January 26, 2021, 3:38pm UTC](https://community.glideapps.com/t/join-columns-and-unite-the-results-in-one-line/21746/12 "2021-01-26T15:38:00Z")
Good to know, can you better explain “work better”? More universally working in different contexts? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 26, 2021, 3:51pm UTC](https://community.glideapps.com/t/join-columns-and-unite-the-results-in-one-line/21746/13 "2021-01-26T15:51:56Z")
Some things, especially on the web or in google sheets, recognize just the carriage return from only the Enter key as a space instead of a carriage return. In some cases adding 2 spaces before the enter signals that it’s a true carriage return. It’s just the nature of HTML. I don’t know the ins and outs of why it’s like that. Just wanted to make you aware if you use the enter key and it doesn’t work as expected. ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [January 26, 2021, 4:17pm UTC](https://community.glideapps.com/t/join-columns-and-unite-the-results-in-one-line/21746/14 "2021-01-26T16:17:08Z")
Ok, which one is better for an email? “br” or “space space enter”? Maybe I’ll make some tests ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 26, 2021, 4:23pm UTC](https://community.glideapps.com/t/join-columns-and-unite-the-results-in-one-line/21746/15 "2021-01-26T16:23:03Z")
I’d say definitely do some tests. Most but not all email clients will process HTML. If you can get it to work fine with the Enter key, then I’d probably use that method. ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/join-columns-and-unite-the-results-in-one-line/21746/16 "2024-01-17T16:53:39Z")