A question came up today on how to write data to excel that have un-equal nested lists.
Sample list content:
And trying to map it to:
This will allow the List.Transpose and Excel.WriteToFile to work correctly.
I have come up with the attached graph but it’s very rigid and is the wrong approach and it also add’s unwanted data.List to Excel.dyn (16.7 KB)