importxml is not working properly -Google spreadsheet

Question

find attached link for my Google spreadsheet in which i tried to pull out the data from booking.com.

i retrieved Hotel name in column. it successfully retrieved the hotel name. but not work with every column. Output is like this.

even i referenced the formula correctly. but it automatically changed to like this..=CONTINUE(E1, 2, 1)

red highlighted cell is having problem. look there.

Please find below link for your reference. Thanks in Advance.

https://docs.google.com/spreadsheet/ccc?key=0AtjX3Ttg50IydHJzR1FMSkJyY0U1bHBSeWtrMDRSZ1E

Answer 1

Some of the calls are going into multiple cells. Try wrapping each importXML function inside noexpand().