Exporting Sublists to Excel

Revit
1

Hi guys

I am trying to list all Electrical elements for each room number. Now I have 86 room names and a list of different electrical elements per room in dynamo but I am stuck in exporting them in the same format into Excel. The best and most efficient way is to export all of them into one sheet in Excel otherwise I have to create 86 separate sheets (each for one room) which is very time-consuming. Could u please help me ij this case?

image
image651×720 83.9 KB

image
image736×648 85.7 KB

Thank u so much in advance

2

Can you try changing the list levels on the transpose node? It may help if you could add a diagram or something showing what format you want to have and what format your currently getting.

1 Like
3

Thanks @SeanP for your response. Can u please show me an example?

Thanks