Hi,
i get data from web which is an XML file with metadata and when loaded it is output like this:
(COLUMN1 / COLUMN 2 is actual header in A1/B1)
<tbody>
COLUMN1
COLUMN2
NAME
John
LOCATION
UK
IDNO
171
NAME
Adam
LOCATION
France
IDNO
189
NAME
Rachel
LOCATION
UK
IDNO
177
NAME...