Hi there. I would like to rearrange xml files in excel in the following format: lat | long | k | v | v If you are familiar with the xml schema I cant repeat column v twice. Essentially what I want to do is make an excel file for all restaurants with lat, long, name and cuisine.

Hi there. I would like to rearrange xml files in excel in the following format: lat | long | k | v | v If you are familiar with the xml schema I cant repeat column v twice. Essentially what I want to do is make an excel file for all restaurants with lat, long, name and cuisine.