Hi!
So I’ve been trying to export data from revit to excel. but I’m having trouble filtering my list and getting a correct output in excel. So far I,ve created two lists (see the image below). List 1 consists of a total of 19 sublists. 12 sublists of walls with 33 items each, 2 sublists of floors with 28 items each, 1 roof sublist with 26 items and 4 foundation sublists with 25 items each. List 2 represents the parameter names, consisting of 33 names.
I would like to sort list 1 based on the input of list 2 see below. Every parameter value should be underneath the right parameter name. See the red boxes in the picture.
m2
- m2
- m2
- m2
- m2
- m2
- m2
- m2
…
Absorptance
- 0.1
- 0.1
- 0.1
- 0.1
- 0.1
- 0.1
- 0.1
…
I,ve tried a couple of things but nothing worked. When I export the file now the image below is the result. This is without combining the lists.
Thanks in advance!