Hello, Adrian. Thanks for very fast response. The problem in your solution is that ipv4 row does not contain the required data and vice versa, the required port and hostname data does not contain ipv4 value in respective column.
In the picture below i've opened the ml with excel. The red values are not there when you open the file. I've added manually red values to show that these lines (row 7-18) are applicable to the upper level ipv4 addr (row 5). But in XML, the data in columns addrtype and addr for rows 7-18 is not displayed. It is just the way how XML structure is built.
I want the report to show me addr, name, portid. Basically filldown the values of row 5 col addrype addre down to row 7-18