# Horizontal dashboard tables
**URL:** https://discourse.nodered.org/t/horizontal-dashboard-tables/72887
**Category:** Dashboard
**Created:** [29 December 2022 12:18 UTC](https://discourse.nodered.org/t/horizontal-dashboard-tables/72887 "2022-12-29T12:18:12Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@mbe23](https://discourse.nodered.org/u/mbe23)
#### Post date: [29 December 2022 12:18 UTC](https://discourse.nodered.org/t/horizontal-dashboard-tables/72887/1 "2022-12-29T12:18:12Z")
Hi! I was wondering if it's possible to create horizontal tables, where the columns are shown as rows.
It would be very useful for a dashboard I'm creating.
Anyone knows how to do it?
Thanks 🙂
---
### Author:  [@tree-frog](https://discourse.nodered.org/u/tree-frog)
#### Post date: [12 January 2023 15:21 UTC](https://discourse.nodered.org/t/horizontal-dashboard-tables/72887/2 "2023-01-12T15:21:32Z")
you can manipulate the data in SQL to pivot your data. Then you send it to your table as required. Look up in w3schools or just a search for SQL piivot, or SQL show columns as rows etc..
You could send your data to a 2D array, or object, even in your flow as a flow.set() in a function, and then load your table as you manage the data from the array.
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [11 February 2023 15:22 UTC](https://discourse.nodered.org/t/horizontal-dashboard-tables/72887/3 "2023-02-11T15:22:23Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.