# Transpose List of Objects

**URL:** <https://forum.inductiveautomation.com/t/transpose-list-of-objects/41430>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [December 11, 2020, 5:36pm UTC](https://forum.inductiveautomation.com/t/transpose-list-of-objects/41430 "2020-12-11T17:36:43Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![valerie.garciakutlu](https://avatars.discourse-cdn.com/v4/letter/v/74df32/32.png) [@valerie.garciakutlu](https://forum.inductiveautomation.com/u/valerie.garciakutlu)\
**Post date:** [December 11, 2020, 5:36pm UTC](https://forum.inductiveautomation.com/t/transpose-list-of-objects/41430/1 "2020-12-11T17:36:43Z")

</div>

Hello. I am new to Ignition and I have a question; how do I transpose the columns/rows of a table. I have a list objects that I am trying to display in the table.  
.

 ![Table](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/0/10b151ea0b73914d03faa356195aa9a37663f6a6.png)

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [December 11, 2020, 6:19pm UTC](https://forum.inductiveautomation.com/t/transpose-list-of-objects/41430/2 "2020-12-11T18:19:29Z")

</div>

How is the data populating now? Likely a script transform would be the best option.

EDIT: Also, will the ‘header’ names also appear in a column, with values in a second column?

---

<div class="post-metadata">

**Author:** ![valerie.garciakutlu](https://avatars.discourse-cdn.com/v4/letter/v/74df32/32.png) [@valerie.garciakutlu](https://forum.inductiveautomation.com/u/valerie.garciakutlu)\
**Post date:** [December 11, 2020, 6:45pm UTC](https://forum.inductiveautomation.com/t/transpose-list-of-objects/41430/3 "2020-12-11T18:45:49Z")

</div>

> [@JordanCClark](#):
>
> lso, will the ‘header’ names also

Right now the value name is displayed in the Header and the value is displayed in the Row. For example, AF\_AcidTempA is in the header and the corresponding value is in the row. Yes, I would want the header names to appear in the 1st column and values in the 2nd column.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [December 11, 2020, 6:46pm UTC](https://forum.inductiveautomation.com/t/transpose-list-of-objects/41430/4 "2020-12-11T18:46:40Z")

</div>

Let me be more clear. How is the data getting into the table?

---

<div class="post-metadata">

**Author:** ![valerie.garciakutlu](https://avatars.discourse-cdn.com/v4/letter/v/74df32/32.png) [@valerie.garciakutlu](https://forum.inductiveautomation.com/u/valerie.garciakutlu)\
**Post date:** [December 11, 2020, 7:04pm UTC](https://forum.inductiveautomation.com/t/transpose-list-of-objects/41430/5 "2020-12-11T19:04:01Z")

</div>

I have the session custom property AcidFarm folder binded to the Table data object 0.

 ![binding](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/a/ea7829393634c76b25fc85724dbe1abfe1ca1640.png)

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [December 11, 2020, 8:17pm UTC](https://forum.inductiveautomation.com/t/transpose-list-of-objects/41430/6 "2020-12-11T20:17:22Z")

</div>

Bind it to props.data instead of props.data[0]. Then add a script transform (located under the binding settings):

```auto
	newList = []
	for key in sorted(value.keys()):
		obj = {'name':{'value':key}, 'setting':{'value':value[key]}}
		newList.append(obj)
	return newList

```

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/3/c327230c031ecbbc405a2c1ff598d8b1be4f80da.png)

---

<div class="post-metadata">

**Author:** ![valerie.garciakutlu](https://avatars.discourse-cdn.com/v4/letter/v/74df32/32.png) [@valerie.garciakutlu](https://forum.inductiveautomation.com/u/valerie.garciakutlu)\
**Post date:** [December 11, 2020, 8:43pm UTC](https://forum.inductiveautomation.com/t/transpose-list-of-objects/41430/7 "2020-12-11T20:43:10Z")

</div>

Works great! Thank you so much!