Converting XML data to a table

Hello all,

I am trying to reach out to our organisation's HR data and shape the data on PowerBI Desktop.

We are connecting through API and the data structure is XML.

When I connect to the directory, data is visible as below:

When I open the query editor, what I see is below (as the next step I am expanding the tables to see the data):

After expanding the tables; now I see:

However, the data structure I need  is like the following:

I tried to convert data using "transpose" in the query, but it didn't work..

You guys have any idea on how to shape the data in a usable format?

Thanks in advance for your support.

Ugur