How to create a table in Google Sheets from an XML output with multiple children levels?
I'm trying to create a table in Google Sheets with data sourced from an XML output. The XML source is here.
Using the below formula gets the following sample output:
Lines 2, 14 and 15 of the output include multiple siblings in one cell for each parent element.
Is there a way to disaggregate those siblings into separate cells?