# Problems with Excel ?!

**URL:** <https://forum.dynamobim.com/t/problems-with-excel/14022>\
**Category:** Revit\
**Created:** [August 15, 2017, 10:58pm UTC](https://forum.dynamobim.com/t/problems-with-excel/14022 "2017-08-15T22:58:25Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![m\_elgehani](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/m_elgehani/32/30640_2.png) [@m\_elgehani](https://forum.dynamobim.com/u/m_elgehani)\
**Post date:** [August 15, 2017, 10:58pm UTC](https://forum.dynamobim.com/t/problems-with-excel/14022/1 "2017-08-15T22:58:25Z")

</div>

![1](https://cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex022/uploads/dynamobim/original/3X/5/8/587f5b6874bade233b759396c0ecddb918a41653.jpg)!

i cant export my data from revit in columns , all must be in row , isn’t that what List.Transpose do ? need help on that guys , real thanks

---

<div class="post-metadata">

**Author:** ![m\_elgehani](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/m_elgehani/32/30640_2.png) [@m\_elgehani](https://forum.dynamobim.com/u/m_elgehani)\
**Post date:** [August 15, 2017, 10:59pm UTC](https://forum.dynamobim.com/t/problems-with-excel/14022/2 "2017-08-15T22:59:31Z")

</div>

![2](https://cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex022/uploads/dynamobim/original/3X/3/3/33d539864871acc3b7d54c37c1b1e6b15d18e73e.jpg)

---

<div class="post-metadata">

**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\
**Post date:** [August 16, 2017, 3:01am UTC](https://forum.dynamobim.com/t/problems-with-excel/14022/3 "2017-08-16T03:01:04Z")

</div>

Can you put a watch node on the list.create node? Your data may have already been in the right structure, and the list.transpose would put it in the opposite structure in this case.

---

<div class="post-metadata">

**Author:** ![nainoorpatel](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nainoorpatel/32/33085_2.png) [@nainoorpatel](https://forum.dynamobim.com/u/nainoorpatel)\
**Post date:** [August 16, 2017, 12:31pm UTC](https://forum.dynamobim.com/t/problems-with-excel/14022/4 "2017-08-16T12:31:26Z")

</div>

Hey,  
Not to worry! Just delete the List.Transpose node and let me know if it helped you. If that does not work out, try to interchange the Item0 and Item1 in the List.create node. Hope it helps you. Happy to help!  
Regards,  
Nainoor

---

<div class="post-metadata">

**Author:** ![m\_elgehani](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/m_elgehani/32/30640_2.png) [@m\_elgehani](https://forum.dynamobim.com/u/m_elgehani)\
**Post date:** [August 16, 2017, 7:50pm UTC](https://forum.dynamobim.com/t/problems-with-excel/14022/5 "2017-08-16T19:50:13Z")

</div>

i tried to delete the List.Transpose it was a chaos  
But i tried to remove the List.Create and tried to do it for 1 Category it worked fine , But i need to do that for 7 Elements , is there any other thing to do ? lots of thanks

---

<div class="post-metadata">

**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\
**Post date:** [August 16, 2017, 8:19pm UTC](https://forum.dynamobim.com/t/problems-with-excel/14022/6 "2017-08-16T20:19:18Z")

</div>

It’s probably because your `overWrite` input is defaulting to `false`. You need to allow the script to overwrite the existing data. Try making the input `true` and see if that helps.