0

I used this formula in Google Sheets :

=importxml("https://www.investing.com/equities/aboitiz-equity-balance-sheet","//tr")

However, it is a nested table, so the values are not formatted properly

Symbol  Exchange    Currency    
AEV Philippines PHP Delayed
ABTZY   OTC Markets USD Delayed
Period Ending:  202030/09   202030/06   202031/03   201931/12
Total Current Assets    149486.88   157703.15   157060.05   124425.29
**" Cash and Short Term Investments 65403.14 75288.51 76796.66 46424.66 Cash - 
- - - Cash & Equivalents 65403.14 75288.51 76796.66 46424.66 Short Term 
Investments - - - - Total Receivables, Net 38594.89 39947.7 35037.43 
35195.59 Accounts Receivables - Trade, Net 38594.89 39947.7 35037.43 
35195.59 Total Inventory 22785.02 22964.64 24199.83 23347.72 Prepaid 
Expenses - - - - Other Current Assets, Total 22703.83 19502.29 21026.12 
19457.31 "**                
Cash and Short Term Investments 65403.14    75288.51    76796.66    46424.66
Cash    -   -   -   -
Cash & Equivalents  65403.14    75288.51    76796.66    46424.66
Short Term Investments  -   -   -   -

How to format the table properly?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.