# Dynamo export excel (change col to row)

**URL:** <https://forum.dynamobim.com/t/dynamo-export-excel-change-col-to-row/42968>\
**Category:** Revit\
**Tags:** dynamo\
**Created:** [November 9, 2019, 5:59am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-change-col-to-row/42968 "2019-11-09T05:59:01Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![chanob9104](https://avatars.discourse-cdn.com/v4/letter/c/13edae/32.png) [@chanob9104](https://forum.dynamobim.com/u/chanob9104)\
**Post date:** [November 9, 2019, 5:59am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-change-col-to-row/42968/1 "2019-11-09T05:59:01Z")

</div>

What should I do?

 ![1](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/d/ad88b1f3ac2a81172b915a26c11a166e0ab23ca3.png)  
It’s like this now

 ![2](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/e/2e36deea557bee7da2fe1f1b93c44211dd145a31.png)  
second picture is the format I want  
What should be modified to make it look like a second picture?

---

<div class="post-metadata">

**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\
**Post date:** [November 9, 2019, 6:18am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-change-col-to-row/42968/2 "2019-11-09T06:18:55Z")

</div>

Hi @chanob9104

Add List.Create to get the format which you want:

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/8/c/8cb15e2b79bdb65a60368102658b1bceb36173d5.png)

---

<div class="post-metadata">

**Author:** ![blsalvio](https://avatars.discourse-cdn.com/v4/letter/b/ad7895/32.png) [@blsalvio](https://forum.dynamobim.com/u/blsalvio)\
**Post date:** [November 11, 2019, 12:37am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-change-col-to-row/42968/3 "2019-11-11T00:37:56Z")

</div>

Hi,

If you want to change column to row or vice-versa the data before exporting to excel. You can always use the List.Transpose node.

-biboy ![%E3%82%AD%E3%83%A3%E3%83%97%E3%83%81%E3%83%A3](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/2/a252f18ba737e4cbcbd4e5527498691cf18e2df4.png)

---

<div class="post-metadata">

**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\
**Post date:** [November 11, 2019, 12:47am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-change-col-to-row/42968/4 "2019-11-11T00:47:19Z")

</div>

@blsalvio List.Transpose works if you have more than 1 list. In his case he has only 1 list.

---

<div class="post-metadata">

**Author:** ![blsalvio](https://avatars.discourse-cdn.com/v4/letter/b/ad7895/32.png) [@blsalvio](https://forum.dynamobim.com/u/blsalvio)\
**Post date:** [November 11, 2019, 1:00am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-change-col-to-row/42968/5 "2019-11-11T01:00:43Z")

</div>

Hi Kulkul,

If you check the output list (the output of the node before going to the Data.ExportExcel), it is not a [1,2,3] (1D) formatted list, it is [[1],[2],[3]] (2D). List.Transpose will work on that.

-blsalvio

---

<div class="post-metadata">

**Author:** ![blsalvio](https://avatars.discourse-cdn.com/v4/letter/b/ad7895/32.png) [@blsalvio](https://forum.dynamobim.com/u/blsalvio)\
**Post date:** [November 11, 2019, 1:14am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-change-col-to-row/42968/6 "2019-11-11T01:14:48Z")

</div>

> [@chanob9104](#):
>
> What should I do?
> 
> ![1](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/d/ad88b1f3ac2a81172b915a26c11a166e0ab23ca3.png)  
> It’s like this now
> 
> ![2](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/e/2e36deea557bee7da2fe1f1b93c44211dd145a31.png)  
> second picture is the format I want  
> What should be modified to make it look like a second picture?

My bad, I was looking at the output of the Data.ExportExcel.

---

<div class="post-metadata">

**Author:** ![titomoura](https://avatars.discourse-cdn.com/v4/letter/t/b782af/32.png) [@titomoura](https://forum.dynamobim.com/u/titomoura)\
**Post date:** [March 16, 2020, 11:43am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-change-col-to-row/42968/7 "2020-03-16T11:43:24Z")

</div>

I have a question. How could I set up the script to count the elements with the same especification rather than repeating it in the list?