# Pivot Columns with Special Characters Display Incorrectly

**URL:** <https://community.holistics.io/t/pivot-columns-with-special-characters-display-incorrectly/2065>\
**Category:** Report Bugs\
**Tags:** visualizations\
**Created:** [September 6, 2024, 5:16pm UTC](https://community.holistics.io/t/pivot-columns-with-special-characters-display-incorrectly/2065 "2024-09-06T17:16:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Becca\_Perry](https://community.holistics.io/user_avatar/community.holistics.io/becca_perry/32/1741_2.png) [@Becca\_Perry](https://community.holistics.io/u/Becca_Perry)\
**Post date:** [September 6, 2024, 5:16pm UTC](https://community.holistics.io/t/pivot-columns-with-special-characters-display-incorrectly/2065/1 "2024-09-06T17:16:47Z")

</div>

I have a list of business names I am pivoting on. One of the businesses has an & in their name, e.g. “Food&More.” It shows up like “Food&More” as the label at the top of the pivoted column.

The same name used as a Row displays correctly: "Food&More.

---

<div class="post-metadata">

**Author:** ![kaid](https://community.holistics.io/user_avatar/community.holistics.io/kaid/32/12_2.png) [@kaid](https://community.holistics.io/u/kaid)\
**Post date:** [September 9, 2024, 3:34am UTC](https://community.holistics.io/t/pivot-columns-with-special-characters-display-incorrectly/2065/2 "2024-09-09T03:34:07Z")

</div>

Hi @Becca_Perry,

Do you mean it shows something like “Food&amp;More”?

If so, please try using the HTML format for the business name field

 ![image](https://community.holistics.io/uploads/default/original/2X/e/e64d0b2ff10e55021b012b889dbf4419e94d84ab.png)

---

<div class="post-metadata">

**Author:** ![Becca\_Perry](https://community.holistics.io/user_avatar/community.holistics.io/becca_perry/32/1741_2.png) [@Becca\_Perry](https://community.holistics.io/u/Becca_Perry)\
**Post date:** [September 11, 2024, 7:41pm UTC](https://community.holistics.io/t/pivot-columns-with-special-characters-display-incorrectly/2065/3 "2024-09-11T19:41:35Z")

</div>

That fixed it! Thanks for the solution.
