convert - format xml to excel vba

Hello
I have enherited from a file created by another person, the file is supposed to upload XML data fields into an Excel file, format them in a specific way and place each value according to the XML.
the problem is that when a value in the XML is null, instead of showing no data on the corresponding cell in the Excel file, it takes the next value of the same field name and overrides it, which causes misalignment of data, shifting up those cells values to fill the blank cells instead of maintaining them empty.
I have attached the file with samples.
table 1 is what is supposed to happen, table 2 is what is happening.
would appreciate your support on finding the error in the code.
Thanks

Thanks WideBoyDixon, attached.
As I could not amend the file to de-identify the data, i only have one line of info. hope this can work to fix the macro.
I also changed the extension of the file as it was giving me an upload error on this forum (due to file format)
Looking forward to your help
Rgds

Thanks a lot, worked like a charm...
Appreciated