How to use FILTERXML to have all the mapped items of an XML source?

when I use FILTERXML I obtain only the first result.

Look in example at:


How to obtain all mapped items?

Thank you

This must be set as an array. Select the number of cells for returned information, open Function Wizard, enter your formula as stated in your question and turn on Array (lower left corner):

Select OK will produce:

image description