# How can a perspective table component switch rows and columns?

**URL:** <https://forum.inductiveautomation.com/t/how-can-a-perspective-table-component-switch-rows-and-columns/68935>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [January 23, 2023, 8:31pm UTC](https://forum.inductiveautomation.com/t/how-can-a-perspective-table-component-switch-rows-and-columns/68935 "2023-01-23T20:31:06Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Frank\_L](https://avatars.discourse-cdn.com/v4/letter/f/839c29/32.png) [@Frank\_L](https://forum.inductiveautomation.com/u/Frank_L)\
**Post date:** [January 23, 2023, 8:31pm UTC](https://forum.inductiveautomation.com/t/how-can-a-perspective-table-component-switch-rows-and-columns/68935/1 "2023-01-23T20:31:06Z")

</div>

I have a database table that I am binding to a Perspective table component. It works great displaying all the rows and columns from the table vertically. Is there a way to display the rows horizontally?

---

<div class="post-metadata">

**Author:** ![plo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/plo/32/33875_2.png) [@plo](https://forum.inductiveautomation.com/u/plo)\
**Post date:** [January 30, 2023, 11:17pm UTC](https://forum.inductiveautomation.com/t/how-can-a-perspective-table-component-switch-rows-and-columns/68935/2 "2023-01-30T23:17:03Z")

</div>

Hello Frank\_L,

No, there is no way to make the column headers be rows to display horizontally.

But you can submit a feature request to see if this is something that can be implemented in the future. [Ignition Features and Ideas | Inductive Automation](https://ideas.inductiveautomation.com/ignition-features-and-ideas)

---

<div class="post-metadata">

**Author:** ![MCC](https://avatars.discourse-cdn.com/v4/letter/m/3e96dc/32.png) [@MCC](https://forum.inductiveautomation.com/u/MCC)\
**Post date:** [February 5, 2024, 5:16pm UTC](https://forum.inductiveautomation.com/t/how-can-a-perspective-table-component-switch-rows-and-columns/68935/3 "2024-02-05T17:16:21Z")

</div>

Added a feature request [here.](https://inductiveautomation.canny.io/ignition-features-and-ideas/p/perspective-table-transpose-rows-and-columns). Please vote for it if you want this feature!

---

<div class="post-metadata">

**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\
**Post date:** [February 5, 2024, 5:32pm UTC](https://forum.inductiveautomation.com/t/how-can-a-perspective-table-component-switch-rows-and-columns/68935/4 "2024-02-05T17:32:52Z")

</div>

You can do this now by managing your Data: [[Perspective table] - How to display two columns of row data in multiple lines? - #3 by cmallonee](https://forum.inductiveautomation.com/t/perspective-table-how-to-display-two-columns-of-row-data-in-multiple-lines/83687/3)

---

<div class="post-metadata">

**Author:** ![Steve\_Laubach](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/steve_laubach/32/60900_2.png) [@Steve\_Laubach](https://forum.inductiveautomation.com/u/Steve_Laubach)\
**Post date:** [February 5, 2024, 8:41pm UTC](https://forum.inductiveautomation.com/t/how-can-a-perspective-table-component-switch-rows-and-columns/68935/5 "2024-02-05T20:41:00Z")

</div>

If your backend is SQL server I would recommend pivoting the data in a stored procedure. That's a set-based operation and it can be offloaded from your Ignition Gateway (assuming your SQL server is on another machine). More saleable.

You can probably do this in other SQL technologies but I am certain you can do it in TSQL.