# How to remove whitespace from a template a of columns with empty entries

**URL:** <https://community.glideapps.com/t/how-to-remove-whitespace-from-a-template-a-of-columns-with-empty-entries/41308>\
**Category:** Ask for Help\
**Created:** [April 27, 2022, 5:42pm UTC](https://community.glideapps.com/t/how-to-remove-whitespace-from-a-template-a-of-columns-with-empty-entries/41308 "2022-04-27T17:42:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ANS\_Mermer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ans_mermer/32/15962_2.png) [@ANS\_Mermer](https://community.glideapps.com/u/ANS_Mermer)\
**Post date:** [April 27, 2022, 5:42pm UTC](https://community.glideapps.com/t/how-to-remove-whitespace-from-a-template-a-of-columns-with-empty-entries/41308/1 "2022-04-27T17:42:32Z")

</div>

Hello,

I have a spreadsheet with records of SKUs. Each SKU has a “Sales description” which is compiled of certain characteristics of the item. For example: dimensions, category, finish, etc.

Some of the items do not use each characteristic and in creating a template, I’ve found that extra whitespace is filled in wherever a characteristic is empty.

How can I structure my spreadsheet so that if a characteristic is empty, an extra whitespace is not generated and only leaves one space in between each entry to create a final templated cell.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/0/70b42f165e7be781a02cd9df3a9e7f19b1480e07.png)

---

<div class="post-metadata">

**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:** [April 28, 2022, 12:17am UTC](https://community.glideapps.com/t/how-to-remove-whitespace-from-a-template-a-of-columns-with-empty-entries/41308/2 "2022-04-28T00:17:24Z")

</div>

Here, I assume what you mean by “whitespace” is when two "@@"s are stacked together?

You still want to keep the “@” character in the final template, right?

You can split the “raw” template above by the “@” character itself, then use a joined list column on the split column, join it by the “@” character again.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [April 29, 2022, 12:17am UTC](https://community.glideapps.com/t/how-to-remove-whitespace-from-a-template-a-of-columns-with-empty-entries/41308/3 "2022-04-29T00:17:25Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.