What is the best way to group spreadsheet data by column?
-OR-
How to group lists of arbitrary length in Column C under their heading in Column B, and then group Column B (also arbitrary lengths) lists under heading in Column A?
The solution I came up with (attached below) was to find nulls within my lists and then split the lists based on those null locations. Then carefully merge my split lists into the final structure.
As you can see, my way took very many nodes and seems overly complicated. What is the more efficient way to accomplish this?
Dynamo:
test.dyn (94.8 KB)
Data:
simple.xlsx (8.1 KB)