Sort list in Excel


#1

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!


#2

you should make the list of parameter exactly as the list 1, do the following :

  • Flatten then Transpose List 2
  • use List.Cycle on it with Level of 2
  • the value for List.Cycle should be taken from List.Count from list 1 also with level 2

you should have now List 2 with same count of List 1