'Separate XML data with Import XML on Google Sheets

I am using IMPORTXML in Google Sheets to data pictured from https://www.sherdog.com/fighter/Kelvin-Gastelum-74700

The data output is contained in cell A1. What custom function would I need to separate the data into fields and records as it is displayed on the website?!

Kelvin Gastelum Sherdog Output

I tried using a custom function without success.

google-sheets google-sheets-formula

Solution 1:^[1]

Try

=importhtml(url,"table",2)

you have 9 tables, so you can try =importhtml(url,"table",1) to =importhtml(url,"table",9)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Mike Steelson

'Separate XML data with Import XML on Google Sheets

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]