Thank you for the answer, but it's not exactly how I need it. As for the xml file, I cannot do anything. I see that you used an ID for each row. I cannot use that. and the final display should look like this:

You are interested in pivoting the values for all nodes positioned at specific number. If we extract the text an enumerate the rows then the numbers greater 4, 5 and 6 correspond to (Hostname, DBInstanceName, DatabaseName) and you have a block every 13 rows.