When I use
=transpose(concatenate(IMPORTXML(A1,F21))) all the table data headers & data) is imported into one cell.
Note: A1 is url:
https://wallmine.com/asx/a2m, and F21 is xPath: //div[@data-controller='companies--properties'].
How do I transpose this imported table data in cell C8, into two separate rows:
(A) Headers into row 1, across columns for the length of the data,
(B) Linked data into row 2 across columns for the length of the data.
I tried to transpose header row and data for one stock using the following formula:
=query(importxml(concatenate("https:/wallmine.com/asx/a2m","//div[@data-controller='companies--properties']"),"//td/tr"),"Select Col1, Col2, Col3, Col4, Col 5, Col 6 LIMIT 1"), but it displays N/a, "Could not fetch URL:
I also attempted to get only the data row using:
=transpose(importxml(concatenate("https:/wallmine.com/asx/"&A2&"/'companies-properties'"),"//tr//td")). But received the same error. note cell a2 has the ticker a2m. Both these two above attempts appear to start loading the data, then fails with the error. So what am I doing wrong here ?
I have also used the following function on the combined table data in cell C8=split(flatten(C8)," ,"), it places the headers and data in one row, but headers are placed in multiple columns in error, where a header has a space between header names. (i.e. Market cap has Market displayed in Col1 and cap in Col2. So this does not help me either.
Screen print of merged table date in cell C8, and list of data wanted: i.e. 6 columns by 21 rows.