# How to transpose a dataset using ignition expression?

**URL:** <https://forum.inductiveautomation.com/t/how-to-transpose-a-dataset-using-ignition-expression/83356>\
**Category:** Ignition\
**Created:** [December 20, 2023, 9:38am UTC](https://forum.inductiveautomation.com/t/how-to-transpose-a-dataset-using-ignition-expression/83356 "2023-12-20T09:38:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anamay\_Belekar](https://avatars.discourse-cdn.com/v4/letter/a/c4cdca/32.png) [@Anamay\_Belekar](https://forum.inductiveautomation.com/u/Anamay_Belekar)\
**Post date:** [December 20, 2023, 9:38am UTC](https://forum.inductiveautomation.com/t/how-to-transpose-a-dataset-using-ignition-expression/83356/1 "2023-12-20T09:38:04Z")

</div>

I have a dataset in custom property of a component and in another custom property I want to write the transpose of that dataset. Is it really possible with ignition expression?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 20, 2023, 12:01pm UTC](https://forum.inductiveautomation.com/t/how-to-transpose-a-dataset-using-ignition-expression/83356/2 "2023-12-20T12:01:43Z")

</div>

Not natively, no. But you could do it with my `unionAll()`, `columnInfo()`, and `forEach()` functions in a fairly complex expression. But beware: this will almost certainly yield multiple different datatypes per column, which is not officially supported. (You can force it with `java.lang.Object` column types, but you will likely create problems elsewhere in Ignition.)