# Transpose between columns and rows in table/pivot table

**URL:** <https://community.holistics.io/t/transpose-between-columns-and-rows-in-table-pivot-table/1026>\
**Category:** Feature Suggestions\
**Tags:** pivot-table, visualizations, table\
**Created:** [June 30, 2022, 3:37am UTC](https://community.holistics.io/t/transpose-between-columns-and-rows-in-table-pivot-table/1026 "2022-06-30T03:37:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![di.hoang](https://community.holistics.io/user_avatar/community.holistics.io/di.hoang/32/421_2.png) [@di.hoang](https://community.holistics.io/u/di.hoang)\
**Post date:** [June 30, 2022, 3:37am UTC](https://community.holistics.io/t/transpose-between-columns-and-rows-in-table-pivot-table/1026/1 "2022-06-30T03:37:11Z")

</div>

Yesterday I saw [Dmitry Sofiev](https://community2.holistics.io/u/dmitry_sofiev)’s question: [Pivot Table \> Present Measures as rows in pivot table](https://community2.holistics.io/t/pivot-table-present-measures-as-rows-in-pivot-table/733/4) and realized that I also had the same issue. When I work with a table (or pivot table) that has a lot of columns but a few rows, I’d like to swap its rows and columns to make it look nicer.

If you also want Holistics to support this feature, feel free to share your case and upvote 🔺 this topic 😉

---

<div class="post-metadata">

**Author:** ![lucas](https://community.holistics.io/letter_avatar_proxy/v4/letter/l/ba8739/32.png) [@lucas](https://community.holistics.io/u/lucas)\
**Post date:** [September 2, 2022, 4:29pm UTC](https://community.holistics.io/t/transpose-between-columns-and-rows-in-table-pivot-table/1026/2 "2022-09-02T16:29:39Z")

</div>

Hi,

Often find that my end users want to see tables with columns being the date. Then each row is a different value. For example:

Columns:

- weeks

Rows:

- Sessions (format #)
- Convert rate (%)
- Revenue ($)
- WoW change in Revenue (%)

The above (as far as I know) is impossible to do (with correct formatting) in Holistics.

In Holistics, using Pivot Table I can only do this with rows and columns reversed… I wish I could just click on ‘transpose’ button under Format, then it would just flip the rows and columns for me.

Lucas

---

<div class="post-metadata">

**Author:** ![anya.conti](https://community.holistics.io/user_avatar/community.holistics.io/anya.conti/32/1743_2.png) [@anya.conti](https://community.holistics.io/u/anya.conti)\
**Post date:** [September 16, 2024, 3:58pm UTC](https://community.holistics.io/t/transpose-between-columns-and-rows-in-table-pivot-table/1026/3 "2024-09-16T15:58:01Z")

</div>

I know this is an old thread, but I don’t think this has been implemented yet as far as I can tell. We’d also love to see this feature. Thanks in advance!

---

<div class="post-metadata">

**Author:** ![di.hoang](https://community.holistics.io/user_avatar/community.holistics.io/di.hoang/32/421_2.png) [@di.hoang](https://community.holistics.io/u/di.hoang)\
**Post date:** [January 14, 2025, 9:51am UTC](https://community.holistics.io/t/transpose-between-columns-and-rows-in-table-pivot-table/1026/4 "2025-01-14T09:51:46Z")

</div>

Good news @anya.conti @lucas and everyone!

We’re working on **a new feature that lets you display metrics as rows** (instead of columns) in the pivot table. You can get a sneak peek at its layout in the image below.

 ![Screenshot 2025-01-14 at 14.50.15](https://community.holistics.io/uploads/default/original/2X/f/f769e421d560b4ddabfb603695b5b249bb40bdac.png)

The **first release is planned for February 2025** (right after our Lunar New Year celebrations at the end of January).

Following this, we’ll introduce another **enhancement that allows you to control how metrics are displayed relative to dimensions** : Inside, Outside, or Interleaved. This improvement is expected to launch by late February or early March 2025.

 ![Screenshot 2025-01-14 at 16.48.18](https://community.holistics.io/uploads/default/original/2X/8/86a3aed450e00d7dfa6c2af4abb70ae2ae775058.png)

Stay tuned for these updates. Feel free to let us know if you have any suggestions or feedback! 😊

---

<div class="post-metadata">

**Author:** ![di.hoang](https://community.holistics.io/user_avatar/community.holistics.io/di.hoang/32/421_2.png) [@di.hoang](https://community.holistics.io/u/di.hoang)\
**Post date:** [March 14, 2025, 10:57am UTC](https://community.holistics.io/t/transpose-between-columns-and-rows-in-table-pivot-table/1026/5 "2025-03-14T10:57:04Z")

</div>

Hi there,

We’re excited to share that our **Show metrics as rows in Pivot Table** feature has been available for all users! 🎉  
For detail, please visit our community post here: [[Launched] Show metrics as rows in Pivot Table](https://community2.holistics.io/t/launched-show-metrics-as-rows-in-pivot-table/2411)

We look forward to your feedback once you’ve had a chance to try it! 😊
