Anonymous

<?xml version="1.0" encoding="UTF-8"?>
<Hotels>
	<Hotel hotelid="120318" status="L" countyid="3" rating_type="Star" url_hotel="http://www." url_booking="http://www." url_bookings="http://www.">
	
	<Details name="Tekels Park Vegetarian Guest House" rooms="23" CC_AX="N" CC_DC="N" CC_CA="Y" CC_VI="Y" CC_SW="Y" type="Hotel" childrate="N" currency="GBP"/>
	
	<Location latitude="51.33049011230469" longitude="-0.7327525615692139"/>
	<Address address1="Tekels Avenue" address2="" address3="" postcode="GU15 2LF" town="Camberley" county="Surrey" region="England" country="United Kingdom"/>
	
	<Photos externalImage="http://447234.jpg" barImage="" restaurantImage="http://447235.jpg" receptionImage="" logoImage="" mapImage="" conferenceImage=""/><RoomPhotos roomImage1="http://447240.jpg" roomImage2="http://447244.jpg" roomImage3="http://447242.jpg" roomImage4="" roomImage5="" roomImage6="" roomImage7="" roomImage8=""/>
	
	<Geographical Village="" Borough="" Town="Camberley" Subdivision="" County="Surrey" Region="England" Country="United Kingdom"/>
	
	<Descriptions><Description lang="en">Short</Description></Descriptions><LongDescriptions><LongDescription lang="en">Long</LongDescription></LongDescriptions>
	
	<Rates lowestmidweeksingle="35.0"/><Accolades><Accolade_AA award="None"/><Accolade_RAC award="None"/><Accolade_International award="0"/><Accolade_SelfAccredited award="None"/><Accolade_LocalTouristBoard award="None" board="None"/></Accolades><Amenities/>
	</Hotel>
</Hotels>

-----------------------------

If I start it at "<Hotels>" result of the columns is:

<?xml version="1.0" encoding="UTF-8"?>
<Hotels>
	<Hotel>
	<Details/>
	<Location/>
	<Photos/>
	<Geographical/>
	<Descriptions></Descriptions>
	<Description></Description>
	<LongDescriptions></LongDescriptions>
	<LongDescription></LongDescription>
	<Rates/>

	<Accolades><Accolade_AA award="None"/><Accolade_RAC award="None"/><Accolade_International award="0"/><Accolade_SelfAccredited award="None"/><Accolade_LocalTouristBoard award="None" board="None"/></Accolades><Amenities/>
	</Hotel>
</Hotels>

---------------------