Dynamo export excel (change col to row)

Revit
1

What should I do?

1
12171×1097 208 KB

It’s like this now

2
2771×840 18.9 KB

second picture is the format I want
What should be modified to make it look like a second picture?

2

Hi @chanob9104

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

image
image1605×543 33.8 KB

2 Likes
3

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

4

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

5

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

6

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

7

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?