Been playing with a graph to see if a table such as the one attached can be recreated in Dynamo.
No such luck so far, so I am wondering on how hard would it be to get it to work in Dynamo.
One of the problems is that when grouping the rooms by level, if the room only exists, say, on Level 2, that area is listed at index 0, along with all the other areas on Level 1, which are also listed at index 0. This results in that when writing the the excel, the area on Level 2 shows on the same column as the areas on Level 1.
JRoom Areas by Level_01_v2 JA.dyn (29.9 KB)